I am trying to disable and enable controls based on user security levels. I have created a table with users and their respective workgroups and based a userform on this table.
My problem arises with the code
[user]=CurrentUser()
this only overwrites the first value in the user table though for me.
I want to match the Currentuser() to the respective record in the user table so that I can then retrieve the usergroup the Currentuser is a member of.
Any help would be greatly appreciated
My problem arises with the code
[user]=CurrentUser()
this only overwrites the first value in the user table though for me.
I want to match the Currentuser() to the respective record in the user table so that I can then retrieve the usergroup the Currentuser is a member of.
Any help would be greatly appreciated
