Sorting combo box drop downlist in form

[Douglas]

Howdy all,

I am doing some more work on a db and have run into a bit of a quandry.

I have a table of Handreceipt holders holding information on Name/rank, department, HR code, and phone number. On the form I have a combo box for each field so that you can select someone based on any of the information, however only the code combo box lists things in order (as that was the order key when I entered in all of the inital information). My question is....Is there anyway to make the other drop down boxes show their respective information in a sorted order w/0 having to use more tables? Can I code the box to automatically sort the information for display?

Thanks for all your help!!
Doug

 

[Jerry Stoner]

Base your combo on a query not a table. Sort Asc in the query.

 

[Douglas]

couple question

Do I need to create a query for each one? and If i do will ppl still be able to select the information in one field and have it display the correct and corresponding information in the other fields?

Doug

 

[Jerry Stoner]

There are two ways you can go here.
1) Create a query for each one and use as row source for appropriate cbo. So Row Source = "qryWhatever" This is the method I use.

2) In design view go to row source, click the button on the right and youll be taken to the qbe grid. You can then select your fields and sort as needed. If you use this method the SQL generated by your selections not a query becomes your row source.

My understanding (Thanks pat) is that method 1 is most efficient.

As to question 2 yes all will still work as before.

 

[Douglas]

Thanks guys I'll give that a try!