I have a database which, among other data, includes a person's name and Amateur Radio Call Sign.
In my forms, I use a combo box to select a person to link a new transaction table record to [many to one].
The combo box structure is [Member_ID, Member_Name, Call_Sign]
I sometimes need to look up a person by name and other times by call sign, but I can only design the combo to sort on one or the other. I can manually change the order in Design mode, but that is awkward.
How can I make it, so I can toggle the combo box between the two sort orders with a single click of, perhaps, a second control?