Create a Macro that does the following:
1) "OpenForm" command and select the form you wish users to view after entering the password.
2)"Close" command that closes form "frmPassword"
Save Macro as e.g. "OpenPassword"
Create a new form (frmPassword) with a text box (TxtBoxPassword) and command button.
Right click on the command button,Go To "On Click" Procedure.
Select Event Procedure.
If me.TextBoxPassword = "Type Password Here" then
MsgBox "Incorrect Password.Please Try Again"
-What happens is that when you type the password in the Textbox and click on the command button, The coding will check if the password typed = the hardcoded password.If it's true, It'll run the macro to open the new form.
Hope this helps.