undo sorts button

  • Thread starter Thread starter wallymeister
  • Start date Start date
W

wallymeister

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
 
On Tue, 11 May 2010 07:00:01 -0700, wallymeister

Me.subEditParts.Form.OrderBy = ""
Me.subEditParts.Form.OrderByOn = False

-Tom.
Microsoft Access MVP
 
Thanks Tom
This was way too simple, once again I'm ashamed of myself.
Wally

Tom van Stiphout said:
On Tue, 11 May 2010 07:00:01 -0700, wallymeister

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
Click to expand...
.
Click to expand...
 
Back
Top