I know this has been covered in other questions and the solutions to those questions have put me on a pretty good path to figuring this out, but I'm still coming up short. Here's the scenario:
I have an Access 2003 database, and have been building a form to handle a certain section of my database. I perfected one form and wrote over 2000 lines of VBA to get it working the way I want it to (the basic function of the database is to keep track of evaluation reports and create them using the Word Object Model). So, as I move on to creating the next form (basically another report type) I would ike to just copy the perfected form and rename a few things, since the new form is going to be very similar. I have 6 forms that should be based on this perfected form.
Upon viewing this newly copied form, I get this: "Member already exists in an object module from which this object module derives." I do have a code module, and global variables inside it. But... this seems to not be causing the error. I can comment out each section that produces this error (Form Load, Unload, and Close) but I still get the error when opening or closing the form. What am I doing wrong? Do I need to rename each object on each copied form? Do I need a separate code module for each form? Any help is appreciated, thanks all.
Clint
Start Free Trial
