If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combo Box Wizard problem
Selecting the Combo Box Wizard's third item ‘find a record…’ I’ve noticed
that the resulting combo box is actually sorting based on the Key column (ContactID 1, ContactID 2 and so on in that order) which is hidden and not the ‘Last Name that’s desired. This method as the last record entered being the last item in the combo box pull down list. I created this combo box so we may type in the customers Last Name and the resulting list is Last Name alphabetic order (type in ‘Smith’ and all the Smiths appear) How can I make the combo box sort based truly on the Last Name. Frank Happy Thanksgiving |
#2
|
|||
|
|||
Combo Box Wizard problem
Go into the RowSource property of the combo box, and change the field name
in the ORDER BY clause to the one on which you want the sorting to be done. -- Ken Snell MS ACCESS MVP "Francis Cunningham, Jr." wrote in message ... Selecting the Combo Box Wizard's third item 'find a record.' I've noticed that the resulting combo box is actually sorting based on the Key column (ContactID 1, ContactID 2 and so on in that order) which is hidden and not the 'Last Name that's desired. This method as the last record entered being the last item in the combo box pull down list. I created this combo box so we may type in the customers Last Name and the resulting list is Last Name alphabetic order (type in 'Smith' and all the Smiths appear) How can I make the combo box sort based truly on the Last Name. Frank Happy Thanksgiving |
Thread Tools | |
Display Modes | |
|
|