Sort records in query when form is opened

[Guest]

I have a form that is linked to a query. It is possible to sort on a certain
field in the query when the form is opened?
Ex: I have a field called Account Name, when the form is opened can it sort
on that field so you can scroll through the records in order?

Thanks

 

[Douglas J. Steele]

Create a query that returns the rows in the correct order, and base the form
on the query, rather than the table.

 

[John Vinson]

I have a form that is linked to a query. It is possible to sort on a certain
field in the query when the form is opened?
Ex: I have a field called Account Name, when the form is opened can it sort
on that field so you can scroll through the records in order?

Thanks

Ummmm...

Sure. Open the query in design view. Select "Ascending" on the Account
Name field. Save the query.

Am I missing something?

John W. Vinson[MVP]

 

[Bill Mosca, MS Access MVP]

Patricia

Forms have an OrderBy property. Put the name of the field on that line in
the Properties box.