Order a from by a certain feild alphabetically

[oggsta]

I would have thought this would be fairly simple; although i am struggling to do this from a particular field as the automatic default everytime you open a form, it seems to sort by the primary key

Any help appreciated

 

[jrbarnett]

Go into form design, right click the square in the top left just above the top of the form and choose properties.
Click the data tab and at the top of it put the name of the field in the Order By property.
To sort by two fields, one within another use:
Field1, Field2

so within each field1, it will sort by field2.

You can then save the form.

John

 

[oggsta]

Thanks for the reply, for some reasons it continues to sort by the primary key.

 

[OnTheFly]

If you want it to always default to a particular sort, I would change the record source to a SQL and Sort it there. Order By works but the syntax of what you put in there is fussy. You don't have to create a query, just click on the 3 dots to the right of the Record Source property of the form and build your query.

Hope this helps.