Update Report from Form

[Jim]

Here's my situation:

I have a form in which record(s) are partially completed (some fields
filled with data) at a point in time, then later all the fields are
filled. The last thing on the form is a command button which runs a
macro to send a report by email containing some of the current record's
field's information to another person in the organization where I work.
Problem is, the new information does not appear in the emailed report.
I have to close out of the form, then reopen it (to update the
report), then go to the record I was working on, then run the macro.
Is there some way the report and be updated without having to close the
form or as an alternative, can the macro be modified (even with a
module) to close the form and reopen it to the same record before
sending the email? Two notes: 1. the report is set by query to contain
only information from the current record, and 2. the form itself cannot
be used to send the information, only the report.

Thank to anyone who can help with this.

Jim

 

[Al Camp]

Jim,
On the report Button OnClick, do a
Refresh
' Send Object... etc...
before you open the report, or email it.

 

[Jim]

Well, that worked really nice.

Thanks, Al.

Jim