Want exit key to exit Access altogether, not just the database

[elviajero]

I used Switchboard manager to create a command key on my switchboard to exit the database. If I go into properties on the command button, on click, it brings up the expression builder, with =HandleButtonClick(5) as the expression.

I'd like this command button to exit the Access app altogether, not just the database. Now the button simply closes the current database. Any ideas would be appreciated.

 

[LarryDeLaruelle]

Create an On_Click event for the exit button and use this code:

DoCmd.Quit

Should do the trick.

HTH
Larry De Laruelle
larry1de@yahoo.com

 

[TheVMan]

Couldn't you just edit it's onclick property and tell it to DoCmd.Quit?

V

 

[elviajero]

Thanks, guys. It worked like a charm.

 

[LarryDeLaruelle]

Vman:

You are probably right. From the post, it wasn't clear that an On_Click event existed. It sounded as if the code (=HandleButtonClick(5)) was in the property for the event and not in an associated event procedure.

Either way, we solved the problem.

Larry De Laruelle
larry1de@yahoo.com