Compare Sum of Subform Field to Parent Form Field

I

Ian

I have a subform in datasheet view with a field called quantity. The main
form has a field called total quantity (when a product is received the total
quantity (TotQuan) is marked then its' distribution is recorded in the
subform).

I would like a check before the form is closed (or the record navigated away
from) to ensure that the sum of the subform quantities = main form totquan.

I thought about doing a msgbox in the afterupdate field of the subform but
am not sure where to put the code and how to compare the fields. Thx.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate main form from subform record 0
Click a subform field to open relevant form 4
Trouble associating parent form record to subform's record 1
sum subform to form 4
running a subroutine from the parent form 2
How do I populate a subform field with a value from the main form? 4
First Subform record gets modified when closing form 3
command button to copy parent data to subform field 0

Top