Setting User Permissions using Dlookup

[RachelBedi]

I have a form which needs to be used by particular parties to edit information but should not be available to all users, it is currently set up with a password entry form. Unfortunately people are complaining that they have to enter a password in order to access the form so I am trying to set up a way that Access can check permissions for certain users. I have a users table set up with usernames and a yes/no column for permissions and a function which calls the Windows environment username.



I know I would need to use Dlookup in order to check the permissions column but how would I get the code to also call the username for identification? (the function is called GetUserName)

I am very new to VBA so any help would be greatly appreciated!

[JeroenMioch]

Just put a textbox in the login form and call the machine or username with :
=fOSMachineName()
=fOSUserName()
= Environ("UserName") for network identification

Then check the value of the textbox against your premissions table.