Parameters in queries

[BrendaP]

I have a report that has two sub reports. The sub reports are based on two different queries that have a parameter in each. When I run the report it prompts me to enter the two parameters for each record (there could be 30 or more records), how do I get the parameters to only ask me once and pull all records? My parameter is >[Continued ED Starting After XX/XX/XXXX] and the other parameter is >[Credits Starting After Date: XX/XX/XXXX], so I would like to just enter this information once and return all records with that criteria and not have to enter the information 30 or more times to get all records.

[June7]

You mean parameter, not perimeter - I edited your post.

I NEVER use dynamic parameterized queries. However, might be needed in this case. I absolutely would not use popups in query. Have query reference an input control on a form as the parameter.

Regardless, the prompt should not trigger 30 or more times - only once for each subform.

[BrendaP]

Sorry about that, I am new to access and i'm not sure what you mean to "have query reference an input control on a form as the parameter" Could you explain this for me? Thanks for your help.

[RayMilhon]

If you have a report with 2 sub reports depending on where the sub reports are in the main report the sub reports could fire multiple times the parameter in the query will prompt you each time. If you create a form in your DB and put the parameter in a textbox and enter the parameter in the textbox Then where the parameter is in your Query reference the textbox instead Forms!myform!textbox Then you won't be prompted for the parameter the query will look it up from the form.

[June7]

Build a form for user to input/select filter criteria with UNBOUND controls (textbox, combobox, listbox).

Instead of >[Continued ED Starting After XX/XX/XXXX] use >Forms!formname!controlname.

[orange]

Brenda,
There is information and examples at Martin Green's site.
You could also search his site for Dynamic Reports.
Good luck.

[BrendaP]

OK I created another form and placed an unbound text box on it with the parameter in the control source and it does nothing except it says error. What is the form supposed to be linked to and how do I get the text box to prompt for an answer, I am sorry but I am confused as to how to set this up.

[orange]

Did you look at the link and tutorials/examples I suggested?

Please show us some of your code and error messages etc.

[BrendaP]

I did look through that website I am just unsure as to how to set up the form. If I put the code in the text box and then click view it just says #Name? and should the form be link to a query or a table?

[June7]

The form just has UNBOUND control for user input of a value.

Query references the control as described in post 5.