I have an existing database that is working fine. I took of copy of the database and made some enhancements with the addition of some tbls, queries and forms. This weekend I moved all my new objects (tbls, queries and forms) into the existing database. Everything came over fine. When I tested , all the tbls, queries and forms all work in the previous portion of the database and just about all of the new stuff I add is working with one exception.
I have one group of coding that is getting an error and I am not sure what to do. When the code runs from the form I get the following error.
Compile Error - User Defined type not defined and the error is on the Dim db as DAO.database. I read up on this last night and it says to check something on the Tools/Reference menu. When I tried to do that the Reference was greyed-out.
Not sure what is causing it. Nothing has changed from one version of the database to the other except the addition of some objects. All my other code runs fine.
Any suggestions!!