Sorted Look Up table

  • Thread starter Thread starter Daniel
  • Start date Start date
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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Combo Box 3
Sort with Combo box 2
Access 2007 - Table A lookup values based on Table B 1
A-Z Sorting Combo 2
Limit to Records in a drop down box? 2
How to filter Report 1
Sorting numerically WAS working; not any more. 3
Combo Box 1

Back
Top