Problem with pop up form

[lstantliff]

Hiya! I would like to start by thanking everyone for their time and expertise!!
I created a report with 4 subreports. Each subreport is based on a different query but the same parameters apply to each subreport. When I opened the report, I had to enter the parameters 4 times, one for each query. On another thread, someone advised me to use a form to enter the parameters. I created an unbound form with 4 text boxes for the parameters and on OK and Cancel command button.

Now, when I open my report (RptAnnualProdSum), my form opens (AnnualDialog). I enter my parameters and click OK. The form closes and nothing happens. Attached to the OK button, I have a SetValue macro. Can anyone pinpoint what I may have done wrong?

Also, I'm fairly new to this so easy with the code. I do understand a little about it but you must be very precise about how and where to use it.

Thanks again for the help. I have learned alot ing this forum!!!

 

[Rich]

Keep the form open while the Report is loading

 

[lstantliff]

How do I do that, I never closed the report! Confused!!

 

[Rich]

Open the Form first, then the Report, just keep the form open until you close the Report

 

[lstantliff]

The form is set to open when I open the report. I feel like I need to maybe add an event procedure to the command button OK to not only SetValue, but also to run the report or the subreports. Not sure and have never written an event procedure. Does this make sense?

 

[Rich]

No it doesn't make any sense, I'll tell you again, open the Form before the Report, use a command button on the FORM to open the Report

 

[lstantliff]

Okay gotcha, will rework and try again - Don't ya hate newbies!!

Thanks for the help!

 

[Rich]

Don't ya hate newbies!!

Not in the least, only those that want us to do all the work

 

[lstantliff]

Not in the least, you wouldn't believe how far I have come in just a few weeks. I was chosen for this job because I had a little basic knowledge of Access and the last person they brought in to do this was a programmer. But I'm always up for the challenge. Don't mind learning. This is just way beyond my knowledge - But I'm getting there. I really do appreciate you guys!!