Originally Posted by
ArviLaanemets
The property RowSouurce for Combo14 must be like 'SELECT ManufcturerID, Manufacturer FROM Manufacturer ORDER BY 2 ASC'. On Format tab of Property Sheet, set proper values for ColumnCount (2) and ColumWidths (0;2.5).
Ignore the order any entries are displayed in tables. And hide Objects Pane (the left one where all tables, queries, forms, reports, etc. are listed) from users - to avoid a lot of sorrows in future. Users start with opening form, and for data viewing and entering only forms and reports must be used.
To display records in form sorted, use RecordSource of form like 'SELET * FROM YourTable ORDER BY SortingField ASC', or enter sorting field name as form's OrderBy property, and set OrderByOnLoad = 'Yes'.