Rich,
Forgive me if I am being dense, but I don't understand what you have told me.
I have a main form whose recordsource is a table called Reqs which contains info on each requisition including QtyOrder. This form shows one record at a time.
The subform lists all of the receipts that have been received against that requisition. On that subform is a control called TotRecd which contains the code "=sum(qtyrec)". QtyRec is a field in the table called Receipts that is the recordsource for the subform. There is a one (Reqs) to many (Receipts) relationship established. The main form and the subform work just fine... the TotRecd on the subform is displayed with the correct amount... the only thing I cannot do is evaluate the comparison between TotRecd and QtyOrdered.
When you say "until you leave the record"? Are you saying leave the record on the main form or the subform? The Before and After Update events cannot (to the best of my knowledge) be triggered by vb code. One must type in the control or paste into it.
If I am being hard headed, I apologize, but for the life of me, I do not understand. I just want to be able to skip through the requisitions one at a time and look at the receipts and see if I have received everything that I have ordered. Like I said, the totals work, just not the comparison that changes the colors.
Thanks for your response Rich... I really do appreciate it. Again, I apologize that I don't understand.
- jc -