Refresh a form after a report

[ann tweedie]

I have a form in Access 2000 which has a field the user must fill in to select a report which is in print preview. The first time the report is run everything is ok and after the print preview has been cancelled, we return to the form which still shows the selection criteria. However if after a short time (having left the form open) the user tries to run another report (or even the same report) the report shows no data and the database hangs. I tried coding to refresh the form after the print preview, but this happens before I have a chance to look at the print preview. Does anybody know how I can refresh the form as it sems to solve the problem. I would greatly appreciate any help in this matte
Ann

 

[Scott McDaniel]

The bigger question is what is causing the database to freeze. What code are
you using to open the reports? What code are you using to refresh the form?

I have a form in Access 2000 which has a field the user must fill in to

select a report which is in print preview. The first time the report is run
everything is ok and after the print preview has been cancelled, we return
to the form which still shows the selection criteria. However if after a
short time (having left the form open) the user tries to run another report
(or even the same report) the report shows no data and the database hangs. I
tried coding to refresh the form after the print preview, but this happens
before I have a chance to look at the print preview. Does anybody know how I
can refresh the form as it sems to solve the problem. I would greatly
appreciate any help in this matter

 

[ann tweedie]

code used is DoCmd.OpenReport stDocName, acPrevie
DoCmd.RunMacro ("RefreshMacro") with RefreshMacro having Close Form1
Open Form

----- Scott McDaniel wrote: ----

The bigger question is what is causing the database to freeze. What code ar
you using to open the reports? What code are you using to refresh the form

I have a form in Access 2000 which has a field the user must fill in t

select a report which is in print preview. The first time the report is ru
everything is ok and after the print preview has been cancelled, we retur
to the form which still shows the selection criteria. However if after
short time (having left the form open) the user tries to run another repor
(or even the same report) the report shows no data and the database hangs.
tried coding to refresh the form after the print preview, but this happen
before I have a chance to look at the print preview. Does anybody know how
can refresh the form as it sems to solve the problem. I would greatl
appreciate any help in this matte