dialog box (1 Viewer)

vmorgan

New member
Local time
Today, 04:53
Joined
Jan 19, 2000
Messages
5
I've created a form to serve as a dialog box. Instead of getting several parameter boxes prompting me to open my report I want this dialog box to pop up and I will put in necessary information to open the report. This is what I put in the criteria section of my query: between[forms]![diaglog box]![beginning date]and[forms]![dialog box]![ending date] Why won't this form open when I try to open my report?
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 00:53
Joined
Feb 19, 2002
Messages
42,981
You must open the form yourself in code. Then use a button on the form to run the report. The form must remain open until the report finishes.
 

vmorgan

New member
Local time
Today, 04:53
Joined
Jan 19, 2000
Messages
5
Pat:

I'm very new at this. What do you mean when you say "open the form in code"?
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 00:53
Joined
Feb 19, 2002
Messages
42,981
I can't tell from your post how you are opening the report. If you are opening it from a form, change the form to open the parameter dialog rather than the report and then have that form open the report. If you are opening the report by choosing it from the report tab in the database window, you'll need to change the procedure to open the parameter dialog rather than the report.
 

Users who are viewing this thread

Top Bottom