Combo Box Wizard problem

[Francis Cunningham, Jr.]

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

 

[Ken Snell \(MVP\)]

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.