references question??

[atadbitslow]

I am working on an Access 2000 database and I get a "compile error: user-defined type not defined" on this statement: Dim dbs as database.

Why does this happen??

Thanks!

 

[beetee]

Exactly correct; you have a references problem.

Open a module (or press ^G to get the debug window)

Select Tools-References

Enable the Microsoft Data Objects 3.6 Library

Please, no star for this, the question comes up at least twice a week.

 

[atadbitslow]

Thanks--

Now I get a "Compile error: Method or data member not found" on this line of code:

Set rst=dbs.openrecordset("Select * from res where [ID]=" & Me.ID) . It stops on the .ID at the end of line.

Why is this??

Thanks!

 

[beetee]

You probably don't have a field named 'Id' in your form. Check out the name property of the textbox in question.