I have a perplexing problem. I have a password form that upon successful input of the password the main input form loads. I have some code that hides all the tool bars thus forcing the user to use the commands and controls on the form. However, I cannot get the default menu bar to go away. I am using the following line:
DoCmd.ShowToolbar "Menu Bar", acToolbarNo
This doesn't work.
But when I open the form directly from the database window, the menu bar does go away. Can anyone figure this one out? I just want the form only to show, no tool bars, database window etc. Thanks.

Why not just set the form's popup to yes and maximize when opened?

In form design, properties set Menu Bar=1 – this will stop the menu appearing…….is this what you meant….

Thanks guys, it did the trick!!!