Sounds like a corrupt database or previous compile information hanging out where it shouldn't. Yes, Access does compile your VBA.
Start by taking a back up of the database and putting it in a safe place.
A couple of directions to take.
Perhaps the easiest is to start Access with the /decompile parameter then open your database. This clears any previous compiles of modules you might have renamed along the way, etc. To do this, click Start, then Run... and specify
"C:\Program Files\...path to your MS Office...\MSACCESS.EXE" /decompile
If that doesn't work, create a new database and import everything from the corrupt database.
Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group