change auto sort order on Form

Thanks for your explanation. And thanks to all contributors to this
community. I had teh same type issue and thanks to this thread that issue has
been resolved.

"Van T. Dinh" wrote:

(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)



"Huaqin" wrote in message
...
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!