sql in vb

[Massoud]

Hi.
I want to run a sql command in my vb code using:
docmd.runsql "sql command string"
Is there any way to put the result in recordset variable as we do with tables:

dim docs as recordset
set docs= currentdb.openrecordset(tablename)....

Thanks again.

 

[namliam]

dim rst as dao.recordset
set rst = currentdb.openrecordset("sql command string")

Greetz

 

[Massoud]

Wow That was fast.
But how can I do this using the query name?
Thanks again

 

[Rich]

Set rs = db.OpenRecordset("Your Query", dbOpenDynaset)

 

[woknick]

Could you please explain what db stands for and what dbOpenDynaset is used for?


Thanks

 

[Massoud]

I tested this solution but it produces error: "Too Few parameters. Expected 1"

 

[Pat Hartman]

If the query requires parameters, you need to supply them prior to opening the recordset. See this post for code:
http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=176367#post176367