DAO Parameter Question

  • Thread starter Thread starter Vicki
  • Start date Start date
V

Vicki

When I open the form I want to scroll through the table
and look to see if a specific field has a value in it.
When it opens I get "Compile error: Can't find project or
library" and dbOpenDynaset is highlighted. I've verified
that DAO 3.6 is checked in the reference library. Checked
Help and my syntax appears to be correct. Any ideas?
Thanks for the help.
Here's my DAO setup code -

Open Compare Database
Option Explicit

Dim db as DAO.Database
Dim rs as DAO.Recordset


Set db = CurrentDb()
Set rs = db.OpenRecordset("tblName", dbOpenDynaset)
 
check other references, probably you have missing one. and remove unused
references
 
Back
Top