Create button to sort records on form

[hullstorage]

Here goes

i have a form which i need to sort various fields in ascending and descending order

so i have created 2 buttons above the field but need to find code or macro to sort the fields into descending or ascending

Delivery Date Date Delivered
01/01/08 02/01/08

Any Help Please

 

[boblarson]

Me.OrderBy = "[Date Delivered]"
Me.OrderByOn = True

and

Me.OrderBy = "[Date Delivered] DESC"
Me.OrderByOn = True

Or

Me.OrderBy = "[Date Delivered],[Delivery Date]"
Me.OrderByOn = True

 

[hullstorage]

thanks
worked a treat

 

[boblarson]

Good - glad it is working for you.