If the combobox row source is not a query but is a table then change the ros
source to a query of the table and set the sort order of the query.

If the row source is a Value list, you have edit the row source to list the
items in the desired order.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

MikeJohnB wrote:
Oops forgot to change some of the demo text

Example
The following example shows how you can use the Dropdown method within the
GotFocus event procedure to force a combo box named SupplierID to drop down
when it receives the focus.

Should read

Example
The following example shows how you can use the Dropdown method within the
GotFocus event procedure to force a combo box named """YourComboName"""" to drop down
when it receives the focus.

On point 2 once again, if you are talking about the order in the items
appear in the drop down list, open the Row Source Query in design view again
and select sort Ascending for option one???

Regards
Mike B