I have a main report with a subreport. Each is based on a separate query that has criteria based on a form. The form has two text boxes, the first one for the criteria for the query/main report. The second for the query/subreport. The OK button on the form opens the report in Print Preview. When I move past the first record (one page) to the next record (second page), I get a prompt for the subreport criteria. If I type criteria in again, the page previews. If I leave the parameter blank, the second report previews with no subreport data. I thought by using a form to enter parameters I wouldn’t be prompted multiple times!?!
I found the following on an earlier post and am wondering if this applies to my situation: [indent]
I think you are getting two prompts for parameters as the query is being opened twice. Is the report launched from a form? If it is then provide an intermediate dialog that requests the parameters, these are then passed back to the form launching the report which fills in hidden field(s) on the form with these params. Then in the query instead of prompting for a parameter look it up on the form you launch the report from. This also has the advantage (should it be desired) of being able to prompt the user with the last selection should the report be opened again (assuming the form isn’t closed in the meantime). If the report is not being handled through a form then supply a dummy intermediate form that is hidden after the params are collected and closes after the report is closed.
[/indent]
If so, can someone explain how to set this up?
I’m attaching a sample of my database, too.
Thank you!