Not sure if this will work but.
Try creating a form that all it does is ask for a password and then takes you back to the other form. Then when they click the button it pops up and checks to see if the password is valid.
Public strPassword As String
'Click Event of button where you want to check the password
DoCmd.OpenForm "frmPassword"
If Len(strPassword) > 0 Then
If strPassword = "acctucaly password" Then
'Run what ever code you want here
Else
MsgBox "Password not correct"
End If
Else
MsgBox "Pleae Enter a Password"
End If
'Click Event of Close Button on form Password
strPassword = txtPassword.Value
DoCmd.Close
Hope that gets you started in the right direction
