design changes to subform don't show up

F

Fredrated

I created a form (originally in '97, since converted to xp), using a wizard,
it was a couple of years ago. I made it a subform by dragging it to another
form. I created a custom 'update' property on the subform and call it when a
change occurs on the main form. Works fine, no problem.

But now, when I want to change the subform, for ex, change text box sizes
etc. the changes do not show up when I activate the main form! When I edit
the main form in design view I can make changes in the subform, and if I open
the subform itself in design view (not at the same time obviously) the
changes are present. But when I open the main form the old version of the
subform shows up!

Does anyone know what is going on, why changes to the wizard-created subform
do not show up when the main form is activated?

Thanks in advance for any help anyone can offer

Fred
 
A

Allen Browne

When you open the main form in design view, and make changes to the subform
in place, the changes do not stick? That would indicate a corruption.

Firstly, make a backup of this mdb, without overwriting any exising backups.

Then uncheck the boxes under:
Tools | Options | General | Name AutoCorrect.
Explanation of why:
http://members.iinet.net.au/~allenbrowne/bug-03.html

Then compact the database to get complete rid of this junk:
Tools | Database Utilities | Compact

Now decompile a copy of the database by entering 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"

Compact again.

If everything goes well, you probably have a working database again at this
point. If not, you can rebuild the database by following the 6 steps for the
first symptom in:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html
 
Top