Changes in form not shown on report

  • Thread starter Thread starter Jason Frazer
  • Start date Start date
J

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
 
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
 
Back
Top