newbie question

Hello everyone i have a simple question (I think)
anyways i have an access database that has one 3 tables and 1 query. Now i know how to in DAO to open a table using "Set rs1 = db.OpenRecordset(strRSName1, dbOpenTable)"
as an example but is there any way to open a query? I thought it would be similiar like "Set rs1 = db.OpenRecordset(strRSName1, dbOpenQuery)"

Does this make sense? Thanks for any help

Use:

Code:

---

Set rst = MyDB.OpenRecordset("SELECT * FROM MyTable", dbOpenSnapshot)

---

to open a SQL query.

To open a set query:

Code:

---

Set rst = MyDB.QueryDefs(0).OpenRecordset

---

using a datacontrol.

Dim Sql as String
Sql = "Select * from your table"
Data1.Recordsource = Sql
Data1.Refresh

Structured Query Language is VERY hot!

Yeah...probably the easiest to use 'Standard Interface' to anything in the Universe...