Parameter Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that runs two delete queries and three append queries every time its run. WHat I have is each query has a parameter asking for a date range. Its the same parameter for each query. Is their a way I can have it just promt for the parameter once instead of three times.
 
Is their a way I can have it just promt for the parameter once instead of three times.
Click to expand...

Put an unbound textbox on the Form, and use it as the parameter
instead of a prompt:

=[Forms]![NameOfYourForm]![NameOfTheControl]
 
Back
Top