save form data on button click

[Alkaline]

I have a form that the user can edit values in. Each record in the form has a button to view a report based on that individual record. The data for the report comes from a query. The problem is when I edit values and then immediately view the report, the report doesnt reflect the changes made in the form until I switch to a different record, and go back. So what I need to do is somehow "save" the data in the form when I click the "View Report" button.

Any ideas?

 

[boblarson]

In the code behind the View Report button add this:

If Me.Dirty Then Me.Dirty = False

That should do it for you.