store parameter value for requery

[jalverson]

I have a form based on a query. The query uses a parameter to filter the data to be displayed on the form. The user then enters additional data. I'm using a requery macro to refresh the data after the user completes the data entry. The problem is the user has to enter the parameter value twice. Once for the original parameter and once for the requery.

Is there a way for the requery to use the values from the original parameter instead of having to re-enter the parameter values? If so, how do you store the values from the parameter and pass these values to the requery?

Thanks for you help,

Jeff

 

[ScottGem]

Put an unbound text box on your form (in the form header?). Set the criteria for the query to:

=Forms!formname!controlname

The user will just have to enter the data once in the control and it will be used whenever you requery.

 

[jalverson]

Your suggestion worked perfectly. I have the form and query running as designed. Thanks for your help.

Jeff

 

[ScottGem]

glad to assist