Force Update before generating report

[mg55345]

Hi,

I have a form with a button w/ macro which generates a report based on the entry currently shown in the form. Think of it as a "generate order receipt" function.

I am experiencing problems with data not being updated in the table when a user clicks on the button to generate a report. Not all of the update information is shown on the report when it is generated. Needless to say, this is problematic.

How can I force an update/save on the form before the report is generated so that the report will have the most updated data when it is displayed and pritned?

I tried adding "requery" to the macro and that worked fine, but when I am in the form in "Dataview=Yes" mode, it doesn't work.

Thank you in advance for any advice or pointers!

 

[missinglinq]

Before your line to call for the Macro that runs the report

If Me.Dirty Then Me.Dirty = False

 

[mg55345]

I am not using VBA, I am just using Macro designer. How would I do this? Thanks.

 

[mg55345]

Nevermind, I think I figured it out. Thanks for the code.