ADO parameter queries in Access vba

[Jack]

Hello all,

I have a query in an Access 2002 db with 3 parameters.
When I try to open this query to a recordset object in
vba, I get the error "To few parameters, expected 3", even
though I had these parameters set to controls on a form.

I'm trying to figure out how to assign the parameters
through ado/vba code, including what to put in the query
itself to be substituted with the parameters in code.

Thanks for any help, Jack

 

[Casey]

Look up the Parameters collection if using ADO.

Look up the QueryDef if using DAO.