Open a form sorted

[DOF2001]

Hello,

how can i open a form, using access 2003, sorted by 3 or more fields?


thank sin advance for all your help!

 

[boblarson]

You can set the Order By as it opens. For example, if we have fields of Country, LastName, and FirstName and we want to use the code to open the form and set the order in the order I listed them, it would be:

DoCmd.OpenForm "FormNameHere", acNormal
Forms!FormNameHere.OrderBy = "Country,LastName,FirstName"
Forms!FormNameHere.OrderByOn = True

 

[Joe4]

Another way is if your Form is based on a query, do all the sorting in the query. It should translate over to the Form.

 

[boblarson]

Another way is if your Form is based on a query, do all the sorting in the query. It should translate over to the Form.

Good point Joe. That is the best way if you can do that. If you aren't needing to dynamically change it then just set it in the saved query, or SQL Statement, that you use as a recordsource in place of a table.

 

[DOF2001]

Thank you the the super fast response,

I used Blobarson solution, just what i needed. just one think how can i sorted using one field in descending and other is ascending order.

Thanks again

 

[alansidman]

--Bob;
What does the "OrderByOn" command set to True do?

Alan

 

[DOF2001]

Figure it out Thanks!

DoCmd.OpenForm "FormNameHere", acNormal
Forms!FormNameHere.OrderBy = "Country DESC,LastName,FirstName"
Forms!FormNameHere.OrderByOn = True

 

[boblarson]

--Bob;
What does the "OrderByOn" command set to True do?

Alan

Alan:

Anytime you set a filter you have to turn it on using FilterOn = True and the same goes for sorting. You need to apply the filter you've set by using OrderByOn = True.

 

[alansidman]

Bob:

Got it. Thanks