undo sorts button

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
 
T

Tom van Stiphout

On Tue, 11 May 2010 07:00:01 -0700, wallymeister

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

-Tom.
Microsoft Access MVP
 
W

wallymeister

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing combo boxes and a text box 2
Sort datasheet subform by column with command button on main form 1
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0
Paste options button disappears 0
Office JS api to handle redo/undo , delete event for content control class 0
Remove sort and filters programmatically on form 2
Populate main form from subform record 0
Dynamic Naming of Form Button 3

Top