multiple subforms automatically changes their source object?

  • Thread starter Thread starter LisaB
  • Start date Start date
L

LisaB

I have a form that has 4 different subforms.
whenever I open the main form, all of the subforms source object change to
the source object of the first subform.

for example: in design mode
subform1, Population source object is frmPopulation
subform2, Settings source object is frmSettings
subform3, Contacts source object is frmContacts
subform4, Log source object is frmLog

After I open the from to view it, all of the subforms source objects
automatically change to the source object of the first subform:

subform1, Population source object is frmPopulation
subform2, Settings source object is frmPopulation
subform3, Contacts source object is frmPopulation
subform4, Log source object is frmPopulation

I thought the form was corrupt so I created another form and the same thing
happens. I have created several database programs in Access that had forms
with multiple subforms and have never had this happen before.

Does anyone know why this is happening now and how to fix it.
 
Hi Lisa

Where you see Access confusing different objects, Name AutoCorrect would be
the first culprit to suspect.

Rebuild the database like this:
1. Create a new (blank) database.

2. Before anything else, uncheck the boxes under:
Tools | Options | General | Name AutoCorrect

3. Import everything from the problem database:
File | Get External | Import
 
That seems to have worked, Thank You!

Allen Browne said:
Hi Lisa

Where you see Access confusing different objects, Name AutoCorrect would be
the first culprit to suspect.

Rebuild the database like this:
1. Create a new (blank) database.

2. Before anything else, uncheck the boxes under:
Tools | Options | General | Name AutoCorrect

3. Import everything from the problem database:
File | Get External | Import
Click to expand...
 
Back
Top