You didn't gave any info about your table structures (what would be essential to get better responses) in your post, so I can only guess here, but I...
Well, the value needs to be saved, so if it's not calculated I would just do the subtraction in my head and type in the number. But I understand what...
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...