Locking a form with users and passwords to unlock

[shwilsonjr]

I am using a form for a daily report and would like to have a cmd button to lock the form when the report is complete and be able to unlock the form using a username and password. This is a multi-user form on a network, I would like to allow the managers, director and VP to be able to unlock the form and edit the reports.

 

[pbaldy]

At its simplest, set the various AllowEdits, etc properties to No in design view, then behind your button:

If InputBox(...) = "Whatever" Then
  Me.AllowEdits = True
Else
  MsgBox "Wrong password"
End If