Nothing else is open and I can not open my form. Please tell me there is a
way to fix this without re-creating form!!!!
"Doctor, I don't feel good. What should I take?"
Please post some information about your database that would help someone who
can't see your screen diagnose the problem.
I would suggest a couple of basic emergency procedures:
- MAKE A BACKUP. Your database may be corrupt, and you may need to get back to
at least this point.
- Open the database (hold down the shift key if you have startup code so
you're in just basic Access with no forms open). On the menu select Tools...
Database Utilities... Compact and Repair.
- Type Ctrl-G to open the VBA editor, and select Debug... Compile <my
database>. Correct any code errors, if any; compile again; save; close VBA and
compact again.
There may be something (which of course we can't see) in this form that is
eating memory. Post some information about the form and we'll try to help!
John W. Vinson [MVP]