refresh a form after previewing a report

[ann tweedie]

when i open my form in Access 2000 and run a report in print preview, on return to the form if it is left for a while, the next time I try to run the report, there is no data in the report and the database hangs.
If I print the report instead of previewing it, I can include a refresh macro in the vb and it seems to work, but I don't know how to do this for print preview (I tried it, but the refresh happened before I could preview the report)
I would be very grateful for any help with this
Thanks
Ann

 

[tina]

try putting the refresh macro in the report's OnClose
event instead.

hth

-----Original Message-----
when i open my form in Access 2000 and run a report in

print preview, on return to the form if it is left for a
while, the next time I try to run the report, there is no
data in the report and the database hangs.

If I print the report instead of previewing it, I can

include a refresh macro in the vb and it seems to work,
but I don't know how to do this for print preview (I tried
it, but the refresh happened before I could preview the
report)

 

[ann tweedie]

Tina,
Thanks I did this and it did refresh the form.
Regards
Ann