How do I just add data from another tab to another tab to include in a sum

[jjz0512]

I have a relatively easy/stupid question, sorry. But, I have a listed in previous threads, my latest before this one, where I have a sub form/tab that have field for 10 CME expenses that I need to sum up to display the Balance of CME. I have that working ok, but now I need to subtract the CME Allocation Amount from another table or sub form/tab.

What I would like to do is, display from the Compensation table, CME_AMT, field as a Comp CME Credit on the CME sub form, and sum up the fields Credit and Expenses to come up with the correct Balance of CME on the CME sub form/tab. Once this is done, I can do 1 of 2 options, if possible. Have Comp CME Credit enabled, which comes from the CME_AMT in the Compensation table, to allow the user to change that amount and update the Compensation table. Or, have it disabled and force them to open the Compensation sub form/tab to change it. I prefer the first option.

So, I need the sub form/tab based on 2 tables, Compensation and CME, right? I apologize for asking, but how do I do this?

Your help is always appreciated and thanks for that help in my other threads.

Jay

[jjz0512]

I got the data to pull from and update the 2 tables. But I can't get the data to refresh in both tabs unless I hit the refresh button, I have on the from to do a Forms("DEMOGRAPHICS").[COMPENSATION].Form.Requery on the Compensation form and a Forms("DEMOGRAPHICS").[CME].Form.Requery on the CME Form. I would like to see CMT_AMT update when I change tab forms, but it is working when I change to a different record entirely.