Forms & Reports (A2k/XP)

Topic

New Reply

Hello All:

I have a form that is based on a query. On the form is button that print previews a report. Information on the report is based on the same query. If the user makes a change on the form, that change is not reflected on the report until the form is closed and reopened. I have a feeling I need either a refresh or a requery but am not sure as to where it goes. As always, TIA.

Reply | Quote

Replies

You just need to save the current record before you actually open the report. Something like this should work:

If Me.dirty = True then Runcommand accmdSaveRecord
docmd.OpenReport “… yada yada…”

Reply | Quote

Thanks Mark, that seems to have done the trick.

Reply | Quote