Sorting Multiple fields on a Form.. I just can't work it out.

[Modex]

Hi All,

While I'm in Access mode, I wonder if I could ask one other question that has been troubling me for some time.

I need to be able, on a click of a button to firstly sort a primary field ie "The Date" and then I need to be able to do a secondary sort on the "TIME".

Very much like selecting DATE as the first sorted column and the TIME as the next sorted colum in a query.

I am not sure how do to this in code.

For a Single Sorted column I use:

Me.Date.SetFocus
DoCmd.RunCommand acCmdSortDescending


If I then use

Me.Time.SetFocus
DoCmd.RunCommand acCmdSortDescending

it sorts all the records in the time order and what I actually need is date,then time sorted for that date and then the date and time sorted in that date etc etc.

Any help would be gratefully received.

many thanks

ModeX

 

[PHV]

Simply play with the OrderBy and OrderByOn properties of the Form.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244