form exit routine In CONTROLBOX exit
Posted on 2000-05-05
From my toolbar "EXIT" option.
I run the following.
' close all recordsets and databases
' Unload form
' Compact and Repair databases
MsgBox "Project Reset"
I also want to run this routine from the ControlBox the Main form if someone chooses the "X"
I believe it is the
Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer)
Is it just a matter of placing this same code in this event?
The code doesNOT run the compact and repair routines when I run this in this Event.