Changes in form not shown on report

[Jason Frazer]

When i make a change in the form and hit a report button I don't see any of
the changes i have made in the form. If i change the record and go back and
hit the print button then the changes are shown in the report. I know when
using a query you can update a query using the requery action. How can i do
the same for a table..

Thanks Jason

 

[Jim/Chris]

Before the print report add a save record command

Jim

 

[Fredg]

Jason,

You must save the record changes before you print the report, either by
moving to the next record, closing the form, clicking on the form's record
selector bar, or by code.

Add a line of code to the form's command button just before you open the
report:

DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "ReportName", acViewPreview