Exit ACCESS

[Ligaya]

Hello there,

I have a form that has a comand button to exit the form and ACCESS. I accidentally clicked on a blank area on the form and the database closed and quit ACCESS.

I tried again to see if clicking anywhere the form (not on a control) would result to the same thing and it did.

Can someone please explain why this is and how to prevent it from happening. The form has an exit database button for us to use.

Please advise.

Thank you.

Regards,
Ligaya

 

[Moniker]

You've put the Exit Access code behind the form's OnClick event accidentally instead of on the button's OnClick event.

 

[Ligaya]

Hello Moniker,

Thank you for the prompt reply.

I deleted the exit button and put another command button in its place and made certain that the code was on the OnClick event of the button and tried it out.

I double clicked anywhere on the form and I exited ACCESS, so I am back to square one. Any further thoughts on this would be greatly appreciated.

Regards,
Ligaya

 

[Ligaya]

Hello Moniker,

Further to my email earlier, you are absolutely correct in your diagnosis. I found that I had accidentally entered the code on both the exit button's On Click event and on the detail's On Click event.

Thank you ever so much for your help. Now I can retire for the night!

Regards,
Ligaya

 

[Moniker]

More fun when it's a simple oversight instead of a huge issue. Glad it worked.