undo sorts button
in [Forms]
|
Prev: Displays Allen’s Browne filtered records in another form
Next: Click Image and call label Click event
From: wallymeister on 11 May 2010 10:00 I have a form with a subform that is displayed in datasheet view. When I right click to sort on a column I get A-Z and Z-A options but there is no clear all sorts option so I would like to add a button to clear all sorts. The button is in the detail section beside the subform. The subform name is called [subEditParts]. Can someone help with this, Thanks Wally
From: Tom van Stiphout on 11 May 2010 10:06 On Tue, 11 May 2010 07:00:01 -0700, wallymeister <wallymeister(a)discussions.microsoft.com> wrote: Me.subEditParts.Form.OrderBy = "" Me.subEditParts.Form.OrderByOn = False -Tom. Microsoft Access MVP >I have a form with a subform that is displayed in datasheet view. When I >right click to sort on a column I get A-Z and Z-A options but there is no >clear all sorts option so I would like to add a button to clear all sorts. >The button is in the detail section beside the subform. The subform name is >called [subEditParts]. > >Can someone help with this, Thanks >Wally
From: wallymeister on 11 May 2010 11:58
Thanks Tom This was way too simple, once again I'm ashamed of myself. Wally "Tom van Stiphout" wrote: > On Tue, 11 May 2010 07:00:01 -0700, wallymeister > <wallymeister(a)discussions.microsoft.com> wrote: > > Me.subEditParts.Form.OrderBy = "" > Me.subEditParts.Form.OrderByOn = False > > -Tom. > Microsoft Access MVP > > > >I have a form with a subform that is displayed in datasheet view. When I > >right click to sort on a column I get A-Z and Z-A options but there is no > >clear all sorts option so I would like to add a button to clear all sorts. > >The button is in the detail section beside the subform. The subform name is > >called [subEditParts]. > > > >Can someone help with this, Thanks > >Wally > . > |