Sorting a combo Box

[ceatana]

I'm using a Combo Box as a lookup field to pull up specific records in my database. However, when I set up the Combo Box, it doesn't give me an option to sort it if I choose the "Find a record on my form based on the value I selected in my combo box" option. Is there a way to sort it by a particular column? My combo box pulls up a last name and first name field so that I can select a person's record.

[Beetle]

You sort it using the underlying query that is the row source of the combo box. Open the property sheet for the combo box, go to the Data tab, click the elipse (...) button to the right of the Row Source. This should open the Row Source query, where you can apply a Sort to the field(s) of your choice.

[ceatana]

Thank you!