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

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

On 15 Oct 2006 13:00:24 -0700, "Simon" <(E-Mail Removed)> wrote:

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