Sorted Look Up table

D

Daniel

Hi,

On a form I have a drop down box with some whose data
source is from a table. I have sorted the table, but when
I go to the the form, the values in the drop down are not
sorted. Any ideas why?
 
J

Jeff Boyce

Daniel

Tables are "buckets o' data", and don't have any necessary "order". This is
doubly true if you refer to a table as a source for a combobox.

Instead, create a query against the table, and put your sorting criteria in
the query. Then, use the query as the RowSource for your combobox.
 
Top