Open a Closed Form VBA Access

Question

If there a way to re-open a form that is being closed without Access overloading?

I've got a Modal Form that I want the user to fill out and don't want them to leave that screen until that data is filled.

I've tried just re-opening the form that they're trying to close, but it overloads Access and wont let me do anything at all after that

Andre · Accepted Answer · 2017-09-26 21:46:19Z

2

You can cancel the closing of the form by setting Cancel = True in the OnUnload event.

Private Sub Form_Unload(Cancel As Integer)

    If Not CheckAllDataIsFilled() And Not bCancelButtonClicked Then
        MsgBox "Please fill out all data.", vbExclamation
        Cancel = True
    End If

End Sub

But you should always provide a way of canceling the form, or users will get very upset with you, and they won't refrain from killing Access via Task Manager if there is no other way.

answered Sep 26, 2017 at 21:46

Andre

27.7k7 gold badges43 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Maldred Over a year ago

Does this work on the close button? Maybe I should have clarified that...

Andre Over a year ago

Yes, it does. And on Alt+F4 and Docmd.Close etc.

Collectives™ on Stack Overflow

Open a Closed Form VBA Access

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related