I'm having a little sorting problem that I would really appreciate some help with: I have a datasheet form on tbl_clocks, with a combo box on the field location_id. That combo box will display the actual location from qry_vision_company_location; no real problem there. The problem that I'm having is I want to sort the datasheet by the location name, and if I do the sort in the record source query, it sorts by the ID instead of by the name. The only way I've found around this is to click "ascending" once the form is already open, but that is not a good solution.
I would really appreciate any suggestions on resolving this.
Thanks,
William