Data missing from Report

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
 
R

Rick Brandt

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

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

John Vinson

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

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top