Changing the sort of a form with a command button 1

[rew2009]

I have an Access form that is controled by a query "CientQRY" that has a record source that is sorted or ordered on a field "ClientName". I would like to be able to change that sort to another field "City" in the same query with a command button within the form. How do I do it? Thanks

 

[PHV]

In the Click event procedure of your button:

Me.OrderByOn = False
Me.OrderBy = "City"
Me.OrderByOn = True

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[rew2009]

Thanks PHV, that worked. But I find I now need to have it stay on the record that was selected before the change of ordering. I presume I need something like: if srtA=ID where ID is for the current record then after the change of ordering have "goto record srtA" But I need the correct language and syntax etc. Also, How do I make the ordering "DESC"?

 

[rew2009]

I figured out the "DESC" part of my question. I'll start a new thread on the staying on the record part after reordering. Thanks