sorting combo box list

J

jason

i have a form where i use an unbound combo box to select a record for
editing.

currently the combo lists the records in the order in which they have been
entered but i need it to list the mobile phone numbers in the drop down box
in numerical order. how do i do this?
 
P

PC

jason said:
i have a form where i use an unbound combo box to select a record for
editing.

currently the combo lists the records in the order in which they have been
entered but i need it to list the mobile phone numbers in the drop down box
in numerical order. how do i do this?
Click to expand...

Use the Order by method in the

e.g. Select [MobileNumber], [Field2] from tblTableName Order by
[MobileNumber]
 
Top