add new record - preview report -new data doesn't show

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I add a new record on a form and press the command button to display the
report. The new data added(bill rate-calc. value) does not display. Have to
exit report - go to form navigate back or up one record than show report and
the new record is visible. Do I add refresh - somewhere to the preview of
report code of the onclick event of the command button?????
Thanks,
Barb
 
babs said:
When I add a new record on a form and press the command button to
display the report. The new data added(bill rate-calc. value) does
not display. Have to exit report - go to form navigate back or up
one record than show report and the new record is visible. Do I add
refresh - somewhere to the preview of report code of the onclick
event of the command button?????
Thanks,
Barb
Click to expand...

Your new record is not yet saved and thus does not exist in the table(s)
that the report is looking at. Just issue a save before opening the report.

Me.Dirty = False
DoCmd.OpenReport...
 
Back
Top