Event when user clicks on X on the top right of the login form

[Techno]

I have made a login form that opens when any user opens the access file and want to make the login form so that the user is not able to bypass it.

There are 3 possible ways to escape the login form.

1. Login command button - It take the user after user validation to a different form.



2. Cancel command button - I want to close the Access file when Cancel button is pressed (I still don't have the code, but probably will figure it out).

3. The X on the top right of the form - This is where the problem is....how can I disable it? Is there a way to remove it from the form? If not, what event programming can disable it? Would be grateful for any help.

[Edgar]

You're looking for the close event.

Private Sub Form_Close()
  Application.Quit
End Sub

Play with the form's properties. If you set borderstyle to none with and it's popup, none of the buttons appear. But there is also a property to disable the close button.

[Techno]

Thanks, it worked.

[moke123]

But there is also a property to disable the close button.

The property Edgar's referring to is the Control Box property. Set that to no.

[Techno]

Thank you...