Dialog Box asking for Parameters Keeps popping Up after report is populated (1 Viewer)

vbbbmom

Registered User.
Local time
Today, 14:10
Joined
Jul 12, 2011
Messages
33
I have a sales report that includes 2 sub-reports. The criteria is just simply to enter a Start date and an End date. I first have a dialog form open and I enter the start date and the end date and the query in the report gets the value from the form. My problem is that after the report is open and populated, if I have more than one page, when I navigate to the next page the parameters dialog box opens asking me for the information again.

Not sure why this is happening?
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 11:10
Joined
Aug 30, 2003
Messages
36,133
The form needs to stay open so the report can access the values. It sounds like you're closing it.
 

vbbbmom

Registered User.
Local time
Today, 14:10
Joined
Jul 12, 2011
Messages
33
I was closing the form and that was the problem. Thank you!!!!
 

vbaInet

AWF VIP
Local time
Today, 19:10
Joined
Jan 22, 2010
Messages
26,374
Fyi: Remember to close the form on the Close event of your report.
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 11:10
Joined
Aug 30, 2003
Messages
36,133
Happy to help!
 

Users who are viewing this thread

Top Bottom