sending a value of a parameter to a query

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

If I'm using DoCmd.OpenQuery ... and this query is with a
parameyers, how could I asign a value to the parameter
from VB?

Thanks
 
I'm not sure about doing it from VBA, but you can base the
parameter on an unbound control and have the parameter of
the query call out that control, ie Criteria: [forms]!
["form"]!["control"], and then just have your vba fire in
that form.

That's the best I can do.

-Scott
 

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

Export to Excel with Parameter in Filename 1
Make Table Query with path Parameter 1
Parameter Query Won't Run 0
IN Clause using multi-select form parameter 6
Custom parameter dialog boxes 2
"inter parameter value" 3
Sources for query parameters 10
How to supress Query Parameter prompt dialogs? 1

Back
Top