Rather confusing schema, with table names same as data names within, foreign keys same name as data field in lookup table, use of special characters...
Please tell us in plain, simple English what is the process that you are trying to automate. You are describing HOW you are doing something, and that...
Oooops!!! I just discovered a typo (> instead of =) in my code for cases 2 and 3. That's what happens when you copy/paste: errors get repeated. I had...
OK, I've added lngCatID to the first MsgBox. I also tried editing my original post to add two additional cases, where I'm selecting cboCat as well as...