Two Combo Selection Boxes: Sort Order Problem

[WinDancer]

I have a form that house two record selection combo boxes, one for Customer Name and one for the Tracking number.

Both work as intended and return the correct record.

The problem is with the sort- I used a query for the source. That query will allow either the tracking number to be the sorted order OR the Customer name to be the sorted order.

I need code to make the sort order in the combo boxes on the fly, depending on which combo box the user selects.

Will you tell me how you would handle this?

Thanks, in advance-

 

[WinDancer]

Anyone, please?

 

[edtab]

It appears to me that you are using the same query statement as the source of your two comboboxes. You need to create two queries, one for each combobox and do your sorting on whatever field you need to sort on for each one of them.