I have a label on my start screen that when the user logs in it lookup in a list there desk location, this works well, however I now need to add the ability to have that information update if the supervisor who is logged in puts in a different employees name in a combo box and I want it to update the information in the label
I have this on the label now
LookUp(mapPins,varCurrentUserName='Current Occupant'.DisplayName).Location & " - "
my combobox is called cmb_Employee
Is this possible?
Hi @Dorinda
Set the text property of the label control to
If(
IsBlank(cmb_Employee.Selected),
LookUp(mapPins,varCurrentUserName='Current Occupant'.DisplayName).Location & "-",
LookUp(mapPins,cmb_Employee.Selected.DisplayName ='Current Occupant'.DisplayName).Location & "-"
)
Thanks, Stalin (Microsoft MVP)
Blog - Learn To Illuminate Blog
YouTube - Learn To Illuminate Videos
User | Count |
---|---|
252 | |
126 | |
104 | |
50 | |
49 |