Password access to a form

[CSJM45]

Hi

Does anyone know anything about using a password to restrict access to a form? What's the best way to do it? Also, I'd like to restrict access to controls in that form based on what the password is.

Thanks,

 

[pbaldy]

At the simplest:

If InputBox(...) = "Whatever" Then
  DoCmd.OpenForm ...
Else
  MsgBox "no dice"
End If

Keep in mind a knowledgeable user may be able to get around it. You can lock or disable controls either here after opening the form or in its open event.