MS Office has encountered a problem . . .

[Chris]

I must have done something to a form or its code. Seemingly all of a sudden
when I close my db I get the above message.

I've run into this message a while back and decompiled successfully solving
that issue. This time I cannot get past it. It appears the db is working
fine up until closing when the error occurs -- and it occurs only if I have
opened a specific form that has subforms. (Yes, they are linked properly.)
If I don't open that form the db closes properly.

When the error occurs I check my tables and all my work has been saved.
Seems not a problem -- but...big but. This loose end cannot be good.

Has anyone a solution to attempt?

I am grateful for any help.
Thanks, Chrissy

 

[Jeanette Cunningham]

Chris,
sounds as if some corruption is starting in those 2 forms.
Go to your most recent backup ( you keep regular backups, every day you make
changes to the front end, don't you?) and import that form and subform to
replace the 2 that are causing that error.

Jeanette Cunningham

 

[Chris]

Thanks, I already have. Its only about an hour's work, but I was hoping to
solve my way out of it.

 

[Chris]

A new twist. I rebuilt the forms, same issue. I also used backups and any
backup (I maintain several iterations) I use, including the backend backups,
result in the same closing error with the same conditions.

Help me. Help me, please.
Chrissy

 

[Chris]

Success!

Here's what I had to do since decompile and restoring didn't work.

I make a backup of each subform, then created the subform anew, cut & pasted
all controls and code. That solved the issue.

Now on to the cleanup of aethetics!