refresh a form after previewing a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...
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
Click to expand...
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)
 
Back
Top