db = currentDB() error

[Pantelis]

In my forms code I use as usual the following

Dim db as Database
db = CurrentDb( )

This time I got an error:

compile error:
Invalide use of property.

I use Access2000 and of course in the referense is the DAO 3.6 Object
library .

Any ideas please

 

[Lynn Trapp]

Change Dim db as Database to Dim db as DAO.Database

 

[Pantelis]

I feel so same.

I forgot to put SET!!!!!!

So it's SET db = currentDb( )

 

[Ron Weiner]

See if

Dim db As DAO.Database
db = CurrentDb( )

makes it all better.

Ron W

 

[StevenM]

-----Original Message-----
In my forms code I use as usual the following

Dim db as DAO.Database
db = CurrentDb( )

This time I got an error:

compile error:
Invalide use of property.

I use Access2000 and of course in the referense is the DAO 3.6 Object
library .

Any ideas please

 

[Carl Rapson]

Try this:

set db = CurrentDb

Carl Rapson