I am replacing my drop down control with a combo box to achieve the searching capability. I have below expression for items property on drop down control which works great and loads the values into a drop down control.
Sort(AddColumns(tblPersonnel, "Fullname", PersonnelFirstName & " " & PersonnelLastName ),Fullname,Ascending)
When I use the same formula mentioned above for items property of a combobox, I get to see below.
Can someone please help me modify the formula, thanks in advance.
Solved! Go to Solution.