Hide and Unhide a form from different users

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,
Is there any way to hide a particular form from a particular user of Access when he logs in through the Workgroup I created
Please Anybody help me.

Thank

Cily
 
Hi All,
Is there any way to hide a particular form from a particular user of Access when he logs in through the Workgroup I created?
Please Anybody help me..

Thanks

Cily
Click to expand...

Validate the user with the CurrentUser function:

Assuming a command button to open the form; when the main form (with
the button) is opened check the user and disable or make invisible the
button.

If CurrentUser = "theuser" Then
Me.cmdToOpenForm.Visible = False
End If


- Jim
 
Back
Top