Creating a report from a form & a parameter query

[Peschtra]

I have a database that I want to make a report based on a form that pulls from a parameter query. It kind of works. I open the report and I get the form to enter the parameter, which pulls the query, but then I get another dialog box before I can get the report.




I don't know how this site works, but I am hoping someone can look at what I am doing and help me. I am new to using the code builder and have tried to get some help from the Google.


I posted a copy of the database here:
https://dl.dropbox.com/u/17432409/EC...se%20vb2.accdb


If you run the report, use Kupfer as the case manager.


Thanks,
PK

[June7]

First of all, there is no need to open the query prior to opening the report. Second, I've never seen anyone have report open filter criteria form. Most people open form, enter filter criteria then have button open report.

The input prompt happens because the form closes before the report runs so the parameter in the query has nothing to get data from. Doesn't matter if the query is sitting there open, running the report forces the parameter to again look for the form for input.