Drop Down List

[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?

 

[Ken Snell \(MVP\)]

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.

 

[Saxman]

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.

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

Thanks.