change auto sort order on Form

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

Guest

Hi everyone, I have a form ABC built based on other tables using Wizard,
itself has no table associate to it. I don't use report because I have to
match the hard copy of the form. When I run the form, it seems to sort it
iitself by first name, can I change it to by something else like
BeginningDate field? Any help is apprecicated!
 
Instead of using a table as the form's RecordSource, use a query. In that
query, set the sorting order that you desire.
 
(Ken: sorry to differ on this).

The RecordSource of your Form is a Query/SQL String created by the Form
Wizard for you based on the Tables you specified when you created the Form.

Open the Form in DesignView. Open the Properties window. In the "data" tab,
you should see the SQL String. Click somewhere in the RecordSource TextBox
and you should see the Build button ( with 3 dots) appearin on the right.
Click on the Build button and the QueryGrid for the RecordSource will
appear. In the QueryGrid, you can speify the sorting order you want.

HTH
Van T. Dinh
MVP (Access)
 
Van T. Dinh said:
(Ken: sorry to differ on this).


Not a problem! I don't use the Wizards, so I didn't know if the record
source would have been a table or query. Thanks, Van.
 
Thanks Van! It worked. You are the Man.



Van T. Dinh said:
(Ken: sorry to differ on this).

The RecordSource of your Form is a Query/SQL String created by the Form
Wizard for you based on the Tables you specified when you created the Form.

Open the Form in DesignView. Open the Properties window. In the "data" tab,
you should see the SQL String. Click somewhere in the RecordSource TextBox
and you should see the Build button ( with 3 dots) appearin on the right.
Click on the Build button and the QueryGrid for the RecordSource will
appear. In the QueryGrid, you can speify the sorting order you want.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top