Code for ordering forms

[paulmcdonnell]

Hi guys,

Sounds simple but I want a command button to order the form data displayed by date or name or whatever...

Do i need to use code behind the button to change the underlying query or can I do it on the form itself...


I'm not sure what to use to do this on the form

any ideas..
cheers
paul

 

[charityg]

Button_Click()
Me.OrderbyOn=True
Me.Orderby="fieldtoOrderby"

 

[paulmcdonnell]

Thanks Charity.....
Worked ACE!
Do you no how you do the same thing but filternig by the selected value of a combo box?

Thanks again...
PAUL

 

[paulmcdonnell]

err that should be "know"

 

[charityg]

me.filteron=true
me.filter="[fieldname]='" & cboName & "'"