Requery multiple sub forms when clicking Print button on the main form

[Eddy Sincere]

I have a primary form with 6 sub forms. The data gets entered and then you can click a button to print the report. My problem is that the report is not getting the most recent changes because the report query isn't running after the data is updated.



I'm guessing a requery is the way to go but I'm not sure if I have to do a requery for each sub form, or if I can incorporate it into the VBA for the "On Click" event. What's the best/efficient way to perform a requery?

[ranman256]

The requery is ONLY needed to see data on the form. Opening a report actually does the requery for the report.
Are you opening the report using KEY ID for that master record?
Is all the data in the sub form 'saved'? (no in edit mode, 'pencil' on the data record)

Once you saved the data, and pull data from the key, the query will pull all data.

[ItsMe]

When you edit data in a form, the form's recordset is updated. If you want to commit the changes to the table(s), you need to save the form. Saving the main form may be enough. So if you have a print report button on the Main Form you would add something like the following before the code that opens the report.

If Me.Dirty = True then
Me.dirty = false
End If

Depending on the properties of the Main Form and Subforms, you may need to save each of the subforms, too.

[Eddy Sincere]

I thought I had responded to this, sorry for the long delay.

I inserted the code supplied by ItsMe into the main form. Now all the sub forms update before the report runs.

Solved!