set rs = mydb.openrecordset ===== type mismatch 1

[vanti1]

dim db as database, rs as recordset
set db = currentdb





set rs = db.openrecordset("coursesffff", dbopendynaset)

when i run this code i get a type mismatch run time error 13 - it debugs on this line and says that rs is empty

i'm trying to open a table called coursesffff as the recordset.

as per usual thanks for your help
mike

 

[ghubbell]

Mike, You're using 2000 and I bet it won't compile. Check that Microsoft DAO 3.6 Object Library reference again. I see nothing wrong with what you have here. Gord
ghubbell@total.net

 

[Broccoli2]

Access knows about two types of 'RecordSet' - from ADODB and from DAO. You probably want the DAO one, so make it explicit with

Dim rs as DAO.Recordset

Then your 'OpenRecordset' call should work fine.

-Rob