How to know when form is ready with refresh

  • Thread starter Sander from Holland
  • Start date
S

Sander from Holland

Hi fellow Access developers, I hope someone can help with the following
problem. In an order form (actually subfrm) I use a sum() function in the
form footer. This adds upp the delivered items for that particular order. If
the user changes a value, and immediately after that presses a button to
print a report, the program is not yet ready with the sum() function.
Unfortunately I want to check the result of this sum. I could use a wait
function or something, but I would like something more reliable. Do you have
a solution? Thanks!
 
A

Allen Browne

In the Click event procedure of your button, save the record before you
print the order:
If Me.Dirty Then Me.Dirty = False
DoCmd.OpenReport "Report1", acViewPreview, ...
 
Top