Closing non-active forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone tell me the correct coding to close all open forms except the
active form?
 
PRH said:
Can anyone tell me the correct coding to close all open forms except the
active form?
Click to expand...


For k = Forms.Count - 1 To 0 Step -1
If Forms(k).Name <> Me.Name Then
DoCmd.Close acForm, Forms(k).Name, acSaveNo
End If
Next K
 
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 to interrupt a form close? 5
Excel VBA - Problem with Closing Print Preview 0
Form closes anyway 2
Form won't activate 2
Testing for required data entry in form fields. 6
trying to close a form 1
Null Field to Interupt Closing 4
Opening form unexpectedly closes other form 0

Back
Top