Any reason why......

Anyreason why after I declare a rs that it would give me the option to use rs.open? .open does not come up as a choice.

Possibly you don't have a reference to the appropriate object library?

Do you know which one I would need? Using VB 6 with Access 1997.

may be coz, you havent declare it as

Dim rs as Adodb.Recordset

Depends on what you're using. ADO, DAO, ? For instance, if ADO, go under your Project->References menu and select the ADO reference.

I believe it is a DAO...is it the same for that? I tried
Dim rs as dao.recordset and the following code but no luck:

strSQL = "SELECT * FROM Products"
rs.Open strSQL, dbs, adOpenForwardOnly, adLockReadOnly
rs.MoveLast
rs.MoveFirst

it is not giving the .open as a choice

What you just posted is ADO code.

I am a little lost as to the difference. What references need to be added with ADO?

"Microsoft ActiveX Data Objects 2.5 Library". Your version may be different, I think 2.7 is the latest but someone will correct me if I'm wrong

Try Adding Data Envionment.
It will work.

How would I DIM these, right now I have...
Dim Data1 As Database
Dim rs As New ADODB.Recordset

and it is giving me a type mismatch with form load:
Set Data1 = OpenDatabase(App.Path & "\TechHeadsDb1.mdb")
Set rs = Data1.OpenRecordset("Products", dbOpenDynaset)

Thanks for your help

Here is a Sample code for you..

Dim con As ADODB.Connection
Set con = New ADODB.Connection
con.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=c:\anis.mdb;" & _
"Uid=admin;" & _
"Pwd=anis;"
Dim sql As String
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
sql = "select * from employee order by name"
rs.Open sql, con

You're mixing ADO and DAO together.