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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pull criteria from a Form 2
Parameter Query Won't Run 0
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Multiple Parameter Crosstab query filter by form 1
Help with form based parameter query/null fields 7
Query with 2 parameters asks for 3 2
Union Query requesting parameter 12
Access Command button to look up and copy data from a query to a table 0

Back
Top