dim dbs as gives no Database option

D

DAVIDTHO

When I open Access 2000 and go to a form and start writing code I begin with
"dim dbs as", and then the drop down dose not have the option of "database",
and I can go no further. The only solution seems to be to go to an old
instance which happily does work, clean out all that is there and begin with
that. I have tried repairing Office etc etc, and no success. Can anyone
help? Thank you.
 
S

Sandra Daigle

Check your references, chances are that you're missing the reference to the
DAO Library. Open the module in the Visual Basic Editor (VBE) then click
Tools->References. Make sure that the Microsoft DAO 3.x Object Library is
checked.
 
Top