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

[babs]

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

 

[Rick Brandt]

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

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...

 

[babs]

Is this the save in code???

Me.Dirty = False

thanks,
barb

 

[Rick Brandt]

Is this the save in code???

Me.Dirty = False

Yes. That is one of several ways to save the current record in code.

 

[babs]

Thanks so much. It worked!!!

Yes. That is one of several ways to save the current record in code.