Yes, you just add a second hidden control to the parent form that is bound to the GroupID on the Groups subform; then use that as the master field in...
So power BI or whatever else you might be using is not capable of getting one value from each of 2 tables and subtracting them? If not, then as long...
Using only an unbound control on a form, you would have to use vba to store the value, or run an update query (e.g. with a button click) that can get...
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...