Importing a form from another DB giving an error ??

[Jasontm01]

I have a form in a DB that I would like to import into a new one. However, when I do it seems to import fine but I get errors in the form itself. If I click on any button I get a variable not defined error and I get similar errors on anything I do in the form.

As far as I can tell all the form information is intact, I can see the code which appears to be complete but for some reason its not working.

Any suggestions?

 

[Uncle Gizmo]

Are they the same versions of access?

Have you got the same references selected in both databases? To check open a form in design view select >>>> tools >>>>> references, to see.

Try compiling the database that contains the form you’re copying from, probably a good idea to compile both databases anyway.

If that don’t help, then there’s a couple of other things to do.

 

[Jasontm01]

Thanks, I managed to stumble across the problem. The MS DAO was checked in one but not the other. That turned out to be the fix for this one.