Compile Error: Variable not defined

G

Guest

I received some help making two forms recently that have code. I made what I
think are appropriate changes to the forms but now when I try to use the
forms the Microsoft Visual Basic opens up and gives me this error message:
"Compile error: Variable not defined" and hightlights "dbFailOnError". How
do I define this variable and get my forms working again?
 
B

Brendan Reynolds

You likely don't have a reference to the DAO object library. From the VBA
editor, select References from the Tools menu, then find and select
'Microsoft DAO 3.6 Object Library'.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top