Reports and Subreport have same parameters... I only want it to ask once!

[LanieB]

Hello There!



I have a report and a subreport within that report. They have the same parameter [Branch Number]. It keeps asking me for the Branch Number twice before it will display the report. What do I need to do to only have it ask me once. Thank you!

[June7]

Maybe don't put the parameter in the subreport RecordSource query. Use the subreport Master/Child links properties to synchronize the subreport to the main report.

I never use query parameter input prompts. Options:

1. query parameter refers to form controls for input

2. use WHERE CONDITION of DoCmd.OpenReport (or OpenForm) to pass criteria to report or form.