Make some controls on a form invisible based on Windows user log in

[KrisDdb]

I have a form ‘frmMain’ with some labels, and corresponding listboxes and buttons. Each button when clicked opens a report/form and each listbox is coded to show the count of the records in that report/form. The frmMain also has a combo box which lists all the users in our domain. And based on the selection in the combo box, the listboxes and buttons are populated with that particular user’s data.
Now I want the frmMain to make the listboxes and buttons invisible, based on the windows login id i.e, I have different types of users with different security levels and I want to make those listboxes and buttons invisible when a ‘regularUser’ logs in and visible when an ‘administrator’ logs in. I also want to make sure when an admin logs in and selects a ‘regularUser’ from the combo, the listboxes and buttons should be displayed. **I do not want the visibility affected based on the combo box selection. I want the windows login to do so** The combo box IDs and the windows IDs are same.
Can anyone suggest the best way to do this?


Appreciate your thoughts and time.

[June7]

You can get the user's network login user name with Environ("USERNAME") - yes, type it exactly as shown. Access won't recognize Environ but VBA will. Use the Environ value to get that user's category from your user table and set visibility appropriately.

You can create a custom public function that will run Environ("USERNAME") and call that function from textboxes or queries.