QueryClose Event help...

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Hi,

In Excel VBA for a Form there is a QueryClose Event, which
I have used many times & works.

I want to use this same event in Access, however it
doesn't work; it doesnt get triggered.

Even the simple following code does not work:

Private Sub UserForm_QueryClose(Cancel As Integer,
CloseMode As Integer)

Msgbox "Form closing"

End Sub


Nothing happens when form closes.

I even went to Access help & there is help on it yet it
still does not work.

Does Access just not support this Event ?
If so, how can I get it to work ?

Any help would be greatly appreciated.

Thank you,
Jeff

Thank yo
 
Access and Excel have different code libraries that are specific to the
respective application. The reason that you didn't find this in the Access
Help file is that Access does not have such an animal.

To trigger an event when a form closes, use the Form On Close event.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top