Sorting a combo box on a form

[StephenB]

I have form frm_qry_tbl_survey that's based on qry_tbl_surveys which is primarily based on tbl_surveys. tbl_survey has field [physicians] which is set as a combo box that pulls a list from tbl_physicians. The field feeds through the query onto the form. I have set tbl_physicians to sort the [PhyLastName] from A to Z, but my dropdown list on the form keeps the original AutoNumber ID sort instead of alphabetizing the physician's last name. I tried creating a query base on tbl_physician and sorting that and then pulling from that into tbl_survey, but that's not working either. I get the sense I'm missing something obvious. Any suggestions?

 

[audrey]

In your query, in the "sort" cell, select an option (ascending). Keep in mind that access sorts from the leftmost field FIRST. So you might want to move the ID to the right side of PHYS_LAST_NAME. But this might mess up other organization schemes in your database, so after you test it, make sure any other forms/reports/queries will not be affected by the change in your current query. Hope this helps.

Audrey

 

[StephenB]

Thanks, Audrey. Sorting in design worked like a charm.

Thanks, again.
Stephen