Change Query Parameters Using Code:

  • Thread starter Thread starter 123
  • Start date Start date
1

123

Thank you for your help and answer:
I have Query and this query For Example Query1 and this Query have
Parameters (Criteria Like This [forms]![FormName]![ControlName] ok ... --->
can I change this parameters by using VBA Code....
 
You can use VBA to change the value of the control or to rewrite the SQL of
the query. The latter will permanently change the query, so if you need to
change it back, that'll need to be in your code also.
 
Back
Top