declaring a recordset 1

[striker73]

Can someone help me declare a recordset? I am in the habit of using Me.Recordsource ="SELECT * FROM MyTable" and then Me.Recordset.MoveNext, etc. however... I am trying to make a global function and apparently the Me. anything isn't working out. This is what I have so far:

Dim MyRecSet as Recordset
MyRecSet.Source = "SELECT * FROM MyTable"
MyRecSet.MoveFirst
txtTitle = MyRecSet.Fields("Title&quot

I am getting run-time error 91: "Object variable or With block variable not set" when I go to set the source of the recordset. What am I missing? Thanks!

 

[lixie]

Hope this helps...

Dim MyRecSet As Recordset
Dim db As Database

Set db = CurrentDb
Set MyRecSet = db.OpenRecordset("SELECT * FROM MyTable&quot
MyRecSet.MoveFirst
txtTitle = MyRecSet.Fields("Title&quot

Lixie

 

[striker73]

I'm getting the following error: User-defined type not defined. Any idea what's going wrong? Thanks!

 

[striker73]

Nevermind.. I didn't check the Microsoft DAO 3.51 object library in VB. Thanks!!