sending a value of a parameter to a query

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
 
S

SM

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
 
Top