ADO Recordset based on query 1

[cmayer10]

Hi All,
To open a recordset based on a table I typically use:

Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
rs.Open "Select * from [my_tbl]", CurrentProject.Connection, adOpenKeyset, adLockOptimistic

How do I do something similar if I need to pull records from an existing query in my DB? Assume I want all records/fields from the query.

Thanks,
Collen

 

[dhookom]

I would try:

Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
rs.Open "Select * from [my_query]", CurrentProject.Connection, adOpenKeyset, adLockOptimistic

You may get errors if you have any parameters.

Duane
Hook'D on Access
MS Access MVP

 

[cmayer10]

Thanks for the post. Parameters were the problem with my code.

Collen