[RESOLVED] [Access] Recordset with Parameters

[Ecniv]

Is it possible to open it through the recordset object, or will I have to use a command to open the recordset?

[Dnereb]

In ADO:
No recordsets in itself do not have a parameter collection.
You can use a command with parameters to fill a recordset.

In DAO:
You can set the parameters of a predefined Query and open it in a recordset.

[Ecniv]

Thanks - was using ADO so had to create a command, put the parameters in, then execute, setting it to the recordset object.

But I thought I'd ask (because last time I used parameters was in DAO).