Drop Down List

  • Thread starter Thread starter Saxman
  • Start date Start date
S

Saxman

I have a drop-down list that gets its listing from a table 'Therapy'.
There is no other information contained in the table.

My problem is that when used, the list is reversed alphabetically (when it
drops down). I have tried doing a sort in reverse order on the table, but
it makes no difference. Is there a way of overcoming this?
 
Use a query as the combo box's Row Source, not the table itself. Base the
query on the table, and include the Sort Order the way you want it to work.
 
Use a query as the combo box's Row Source, not the table itself. Base the
query on the table, and include the Sort Order the way you want it to work.
Click to expand...

I have found that out now, and it works fine, so all drop-down lists will
be based on queries in future.

Thanks.
 
Back
Top