Recordsets

[FoxStudent]

I am trying to execute the following code in a form load event. Module is defiantly a table in regdata.mdb. However, I keep getting a type mismatch at the last line of this code.
Dim db As Database
Dim CreatMod As Recordset
Set db = OpenDatabase("A:\Interaction\RegData.mdb&quot
Set CreatMod = db.OpenRecordset("Module&quot

Can anyone help me!
thank u

 

[p27br]

If Regdata is the current db, I mean it's the one you're working on, I suggest this :

I wouldn't use Module as a table name cos in access it refers to a module object and may cause problems.

Dim db As Database
Dim CreatMod As Recordset
Set db = Currentdb
Set CreatMod = db.OpenRecordset("Mod",dbOpenTable)