Sorting data in a form by clicking on the header

MsLady

Traumatized by Access
Local time
Today, 06:18
Joined
Jun 14, 2004
Messages
438
Is there a way to sort data in a form by clicking on a corresponding control (e.g. label/txtbox) in the FormHeader?
 
I usually create a custom toolbar. For example include "Find","filter by selection", "remove filter", "sort ascending", "sort descending".
This way you do not have to add it to every form, and it can be used by every form.
You can easily put a command button with the wizard, pick form operation, apply filter. Then you would need to write your code for your filter.
But much easier to let Access do the work for you from a custom toolbar.
 
CEH said:
I usually create a custom toolbar. For example include "Find","filter by selection", "remove filter", "sort ascending", "sort descending".
This way you do not have to add it to every form, and it can be used by every form.
You can easily put a command button with the wizard, pick form operation, apply filter. Then you would need to write your code for your filter.
But much easier to let Access do the work for you from a custom toolbar.
Hi there :)
Thanks alot. Sounds interesting. never thought of it. I'll give it a shot
 

Users who are viewing this thread

Back
Top Bottom