save info when close program

[deekras]

when a user clicks the close button from the main form, i want to save the time and do a few other things. where do i put the code for that?

or is it better to disable that button and force users to use a button that i create (that will have the coding i need behind it)?

 

[Mile-O]

You can put it on the form's OnClose event.

 

[deekras]

i'm talking of the close button that closes the entire program

 

[Mile-O]

Yes, but when you close the whole thing, Access shuts objects down in a first opened, last closed basis.

If you put the code on the OnClose event of the first form you open (your main menu) then the OnClose event will still run as Access closes down the form.

 

[deekras]

just tried it. works great. thanks