VBA code for opening only 1 form while hiding the other.

[akisch007]

Using Access 2013 with VBA code, i create a loginPage Form and that when you login you are granted to the main page. These part i coded but how to open only the LoginPage while hiding the other form to prevent user from seeing & changing it before entering the login/password form. ???
I mean when you open the database, you are prompted the Loginform Page and do not see any form/table in the database...

[mrojas]

Set the window mode to dialog.

Example: DoCmd.OpenForm "frmLogin", , , , , acDialo

This will keep the form open before the next one is opened.

[akisch007]

Yeah, i do it putting it in Dialog form but still any user can bypass the Login Page, i can hide other forms/tables manually but any user can change the options for the Navigation Option.
1. Is there any command to lock the user to stay focus on 1 form then close the form to be granted to the main page, thus preventing the user from accessing other forms/tables.
2. Or using acHidden
??

[akisch007]

Never-mind, i finally solve it, with just 2 macro(consist of AutoExec) one macro for opening the form in read-only and dialog Then another macro for hiding the navigation pane.
Work perfectly,