Opening Design View Exits the database

[Mike555]

Recently I set the OnClose event of an Access Form to DoCmd.Quit. Now, when I try to try to go into design view the database closes and Access exists.

Does the setting that I made cause this to happen? How can I go into design view without Access closing?

Thanks!

 

[CosmoKramer]

You should be able to go directly into design view of the form and modify it. It sounds like you are previewing the form first, then trying to go into design view......

 

[Mike555]

It would not let me go into design at all.

I opened another form in design view, went into the VBA section, then navigated to this form's VBA and removed the DoCmd.Quit statement and everything is back to normal now.

That was a scary situation!

Thanks.

 

[GingerR]

scarey--make sure you have a backup of your db at all times!!!