Hi,
I have a Combo box which lists Part numbers(text), with duplicates. Is there a way to have a distinct list sorted in Ascending order?
Thanks in Advance
Hi @Skybluekid,
Set the combo box data source Items property to the following.
You may need to modify the code depending on the name of your collection and column names.
SortByColumns(
Distinct(colParts, PartNumber),
"Value"
)
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.