Access 2002 changing my subforms' source object property???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm working in Access 2002. I have a large form with about 6 subforms (all
embedded at the same level). When I save the form in Design view, some of
the subforms suddenly have their Source Object property changed from the name
of the correct subform object to the name of one of the other subform objects
on my main form. If I change it back to what it's supposed to be then save
it again, I get the same problem. Sometimes it happens with 2 or 3 of the
subforms, sometimes with just 1. It's insane. Anyone have any idea what's
going on?
 
First thing would be to make sure you have unchecked the Name AutoCorrect
boxes under:
Tools | Options | General

It is very common for Access to get objects mixed up if this option is
turned on. Here's an example of just some of the problems it causes:
http://allenbrowne.com/bug-03.html

After turning that off, compact the database:
Tools | Database Utilities | Compact/Repair

Next, open the form in design view, and compare the Name and SourceObject
properties of your subform controls. These 2 properties do not have to be
the same, but if you have a control with the same Name as a saved form, but
its SourceObject is different, Access might get confused.

If you are still experiencing problems after that, it would not hurt to
decompile the project. Enter something like this at the command prompt while
Access is not running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"
 
Back
Top