Listbox: rowsource different dependent on user level

[cpberg1]

I have a listbox (IncidentStatus) that I want to populate with different choices depending on the users permissions. So far I have the login form working which captures the user level as a global variable (1-4).

I want one of the options in the listbox to be "unselectable" for the lowest user level. Best case, the unselectable choice doesn't even show up in the list. If it has to show up in the list then it must not be selectable.

I have thought through enabled and visible properties which seem like they won't work because they would apply to the listbox as a whole which even the lowest user level needs access to some of the choices in the listbox.

I think that "if then else" in the rowsource gets me down the right path. Something like if user level = 1, then incidentstatus = 1-6, else incidentstatus = 1-7.

Haven't tried to play around with this yet as I'm on my IPad. Just looking to see if I'm headed in the right general direction.

Thanks all!

 

[burrina]

You would need to programmatically change the record source for the combo box based on the user. Just curious, doesn't each user have their own front end of the database?

HTH