Combo box sorting help

M

Mike Busch

I placed a combo box on a form to Find users by last name. I sorted the table
by last name, but when I use the Last name as a sourse in the combo box, the
drop-down is not sorted by last name, any help with this. Thank you in
advance.
 
W

Wayne Phillips

Hi Mike,

Try changing the Row Source property of the combo box so that it contains a
SQL string or alternatively, create a query.

For example, set the Row Source property to: SELECT * FROM TableName ORDER
BY FieldName

If you are not comfortable creating SQL statements like shown above, create
a query in the Access designer and set the Row Source property of the
control to the name of the query instead.

Hope tis help,

Wayne Phillips
http://www.everythingaccess.com/forums
 
Top