Report doesn't show updated data from form

[Guest]

When I update table data within my form and then click the button to preview
my report, the report doesn't show the data I just updated in the form.
Any help would be appreciated! : -)

Thanks,

 

[John Spencer]

Probably, the data hasn't been saved yet.

Add the following line of code in the button event before you open the report.

If Me.Dirty = True Then Me.Dirty = False

That is one method to force the record that is bound to the form to be saved.

 

[Guest]

Hi Jeanette
You need to save the record that you just updated before running the report,
before the open report command line, run this line to save the records

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70