access visual basic program 'type mismatch' error

  • Thread starter Thread starter ted
  • Start date Start date
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)
 
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)
 
Back
Top