How to know when form is ready with refresh

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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, ...
 
Back
Top