Compile error - Method or data member not found

  • Thread starter Thread starter Tcs
  • Start date Start date
T

Tcs

When I try to compile my db, I get an error:

"Method or data member not found"

on the following line, with "DAOdbs" highlighted.

intNmbrOfRecs =
DAOdbs().TableDefs("tblAcctsRecAging_Details_temp1").RecordCount

In my global module, I have:

Global CurrentDb As Database
Global DAOdbs As DAO.Database

and in this module, I have:

Set DAOdbs = CurrentDb

What Access highlighted used to be "Currentdb", but I'm trying to update all the
modules in my db by creating the necessary entries in the global module, remove
redundant entries, and generally improve my code. Guess I slipped up, but I
don't understand the error msg. Can anyone help?

Thanks in advance,

Tom
 
Back
Top