Form Sorting

[jamesormi]

Hi,

I have a continuous form that is made up of a number of fields. On opening of the form and clicking of a button I would like the form to be sorted by a number of these fields ie sort by field1, field2, field3 and field4.

How would I go about this?

Thanks in advance

 

[Datagopher]

So, you want to give the user the option of which fields to sort by? Well, you could do it with a continuous form with some coding or you could take the simple way and have the form as a datasheet and provide the users on training on how to design their own custom sorts, which isn't that difficult to do.

 

[jamesormi]

Dan,

I'm not looking to give the user the option. I want the data to be sorted by ALL fields ie sort by Field1 AND field2 AND field3 and Field4 ...

 

[Datagopher]

If you're just looking to sort on the same fields each time then you can just create a command button and do something like this on its click event.

Me.Form.RecordSource = "SELECT Field1, Field2, Field3 " & _
"FROM Table1 " & _
"ORDER BY Field1, Field2, Field3; "
Me.Form.Requery