Combo box sorting help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top