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