Data missing from Report

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

When i enter data onto a form then click the button on the form to open
up a report do dispaly the information of the form it does not display
it.
The only way i can get it to do it is by closing the form once i have
entereed data this way it updates data and then reopen the form.

If there a way it can up date teh data as i click the view reoprt button
 
Simon said:
When i enter data onto a form then click the button on the form to
open up a report do dispaly the information of the form it does not
display it.
The only way i can get it to do it is by closing the form once i have
entereed data this way it updates data and then reopen the form.

If there a way it can up date teh data as i click the view reoprt
button
Click to expand...

The data has not yet been saved so the report can't see it. In the code that
opens your report add a line to save the record first.
 
If there a way it can up date teh data as i click the view reoprt button
Click to expand...

Sure. Put a line in the VBA code which opens the report (in the Click
event of the view report button), before the line saying OpenReport:

DoCmd.RunCommand acCmdSaveRecord

John W. Vinson[MVP]
 
Back
Top