Prevent user to close tabbed form

[Tore]

rI use the tabbed form layout in access 2007, i.e. I went to Access options
->current database and chose "Tabbed documents". One form is a startup fom
and the main menu of my application. By right-clicking on the main menu tab
the user can choose "Close" and the main menu is shut down.

How can I prevent the user from closing down the main menu form of my
application?

Regards

 

[Tom van Stiphout]

I would argue that if they close it, you should close the whole
application. If we prevent the user from closing it, how can she close
the application?
Anyway, that aside, try this in the Form_Unload event of that form:
if msgbox("Are you sure you want to close the application?",
vbQuestion or vbYesNo) = vbYes then
DoCmd.Quit
else
Cancel = True
end if

-Tom.
Microsoft Access MVP

 

[Tore]

I tried your code and it works for me, thanks.

Regards from Tore