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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate Function 6
Using "OpenRecordset" on Linked Table Issue 4
user defined not defined 1
Auto Email Help 3
ADP Update Table Code 5
can't open recordset 2
No value given for one or more required parameters 3
Compile Error: Type Mismatch 3

Back
Top