Change Query Parameters Using Code:

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....
 
W

Wayne Morgan

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.
 
Top