Closing forms

  • Thread starter Thread starter PE
  • Start date Start date
P

PE

How can I close a form by pressing the Esc key - I've done this to some the
forms in my database but simply cannot recall how!

Al
 
Add a command button to the form.
Set its Cancel property to Yes.
It now responds to the Esc key.

Set its On Click property to:
[Event Procedure]
Click the Build button (...) beside this.
Between the Private Sub ... and End Sub lines, enter:
DoCmd.Close acForm, Me.Name

If it is a bound form, add this line ahead of that one:
If Me.Dirty Then Me.Dirty = False
This works around the bug described in this article:
http://members.iinet.net.au/~allenbrowne/bug-01.html
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How Best to Disable <ESC> Key on Form 13
Trapping "Esc" in VBA 5
Access How Current page of a form Read Only 2
Opening form unexpectedly closes other form 0
Cannot save design changes in table/report in Access 2007 3
Access 2007 and Cancel Key - Strange behavior 4
Esc key press 8
How to close the result window with ESC 3

Back
Top