I have a ComboBox list 2 columns. One column is an ID number and the second column is a persons name. I have the column headings displayed. Is it possible to have the combo box sort on either column by just clicking on the column heading?
I have a ComboBox list 2 columns. One column is an ID number and the second column is a persons name. I have the column headings displayed. Is it possible to have the combo box sort on either column by just clicking on the column heading?
The RowSource of the ComboBox would need to change each time.
I attempted to perform the sorting on the combo (Using On Click) by using an if statement and changing the Row Source to whichever query is needed. I get nothing for my efforts. Can you provide a sample for me to follow? I am using Access 2003.
Now that I think about it, I do not know if you can see the column where the click happens. The control can return the Row selected but the columns are just for display.