HELP PASSWORDING A FORM, HERE'S MORE DETAIL... 1

[chubby]

More than one person needs access to (personnel) form to update personnel records. Is there an easy why to change my code to accomplish this. I'm using Access 97 security I.E. and logging in as chubby. On the open event of my form (in Visual Basic), I did placed the following code and it works fine, but only for one person, all other users are denied access.

Private Sub Form_Open(Cancel As Integer)
On Error GoTo ErrFO
If CurrentUser()<> &quot;chubby&quot; Then
MsgBox &quot;Permission denied.&quot;, vbCritical, &quot;Security Check.&quot;
Cancel = True
End If
ExitFO:
Exit Sub
ErrFO:
MsgBox Err.Description, vbInformation, &quot;Form Open Error.&quot;
Resume ExitFO
End Sub

 

[pflangan]

This looks too simple but why don't you use some logic in your if statement

if ((currentuser() <> &quot;chubby&quot and (currentuser() <> &quot;annie&quot and (currentuser() <> &quot;nora&quot and (curentuser() <> &quot;uncle albert&quot) then
msgbox &quot;please p off.&quot;
cancel = True
end if

all done ;-)

 

[chubby]

WOW, thanks!!! I really need to get hot and learn VBA and stop cutting and pasting other people code in my db...