Simple compile error

[dt2demar]

Hello,

When I try to run my program the compile error I get is:

user-defined type not defined

The highlighted part of the VBcode is:

Dim dbs As Database

What is the problem here? This syntax worked on a form in a different database.

thanks in advance.

DTD

 

[HAH]

Repair the database, this should fix the problem.

HAH

 

[dt2demar]

Repairing the database didn't work. Same error.

Any other ideas?

 

[dt2demar]

Figured it out:

Create reference to DAO and move it into third position of references list.

VBA window's menu
<Tools>;<References>

Thanks anyways!!

DTD