You can add a sort when you build your Combo Boxes.
Or add an ORDER BY to the Row Source.

SELECT CustomerID, FirstName FROM CustomerT ORDER BY FirstName;

Monica
Is what the combo boxes display part of your form's RecordSource?
If so, you can set the corresponding fields in OrderByStr as desired.
However, the form will probably need to have a RecordSource that contains multiple tables and multiple joins.

Lars It isn't part of the RecordSource, that's where I really got tripped up. It's part of a helper table I use for names. I'll continue digging and Googling and let y'all know if I find something.

You could build a query based on the main table and include the "*".

Then, add the tables for each of the combo boxes to the view and be sure to set the relationship showing all records from the main table and only those records from the secondary table(s) where they match the id referenced in the main table. Then, just add the text of each of the combo to the grid at the bottom and they will be there to sort on.

You just have to watch that the query doesn't get too complex to be updatable.

Then, set the record source of your form to that query.

Example, an employee table might have PrefixID, FirstName, MidName, LastName, SuffixID, among other fields.

You would do a query on EmployeeT and include the *

Then bring in the helper table, SuffixT for example, and only include the SuffixText field. And the same for PrefixT, PrefixText (or whatever you call your helper tables.

Then, you'd be able to have your form sort, example, LastName, Suffix, Prefix, FirstName, MidName, or whatever fields you need.

Donald gold star for you! It didn't overcomplicate like I thought it would and bonus, if you refer to it as [Lookup_GtwyCombo].[GtwyName] you can sort by the name in the combo instead of the id in the combo!