I have a subform within a form. This form is good for entering accounting records. The form is HEADER, the subform is DETAILS. In DETAILS there are accounting transactions. In the accounting world, debits (positives in my case) and credits (negatives in my case) need to net to zero. I dont want to let the user leave the DETAILS until they do. What I want to happen is this... if they net to zero, leave DETAILS, and in doing so, a new HEADER record will be created for the next batch. If it does not equal to zero, dont leave DETAILS until adjustments are made to make it equal zero, and tell user about it (I have a vague idea how to do this.. conditional formatting and text).
Okay, I have a SUM() in DETAILS that adds up debits and credits, and it works. I also have in HEADER a control that links to the SUM() in DETAILS, so that the amount will appear in the HEADER footer. I think this is going to be an Event thing... I just dont know what event to use, and how to write the expression/code/VB.
Beer to the first successful answer
Okay, I have a SUM() in DETAILS that adds up debits and credits, and it works. I also have in HEADER a control that links to the SUM() in DETAILS, so that the amount will appear in the HEADER footer. I think this is going to be an Event thing... I just dont know what event to use, and how to write the expression/code/VB.
Beer to the first successful answer