Sort records in query when form is opened

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Create a query that returns the rows in the correct order, and base the form
on the query, rather than the table.
 
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
Click to expand...

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]
 
Patricia

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