Hide and Unhide a form from different users

C

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.

Thank

Cily
 
J

Jim Allensworth

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top