access visual basic program 'type mismatch' error

T

ted

converted a ms 2003 format file to 2007 and get the 'type mismatch' error with these 2 statements; Set dbsDatabase = CurrentDb
Set rstMembers = dbsDatabase.OpenRecordset("students", dbOpenDynaset)
 
D

Douglas J Steele

Ensure that your declarations are

Dim dbsDatabase As DAO.Database
Dim rstMembers AS DAO.Recordset


"ted" wrote in message

converted a ms 2003 format file to 2007 and get the 'type mismatch' error
with these 2 statements; Set dbsDatabase = CurrentDb
Set rstMembers = dbsDatabase.OpenRecordset("students", dbOpenDynaset)
 
Top