Continuous Form, Sort Button

[november]

I would like to know if there's a way to create a button that would sort the query on a continuous form.



I am putting together a database for my Product Managers and I want them to be able to sort by the supplier and by their relationship identifier.


Need:

• Button to sort query on continuous form.
• Use onClick for the labels to sort ass./desc.

 

[gemma-the-husky]

your users should be able to click any item in the form/subform, and then click A-Z to sort on that field. (they can clcik ALL or PART of a field, and filter on that as well

i have found that when this happens, you sometimes lose the * record - ie you cannot add records to a sorted or filtered selection

and sometimes its hard to unsort it back to the default

 

[november]

your users should be able to click any item in the form/subform, and then click A-Z to sort on that field. (they can clcik ALL or PART of a field, and filter on that as well

i have found that when this happens, you sometimes lose the * record - ie you cannot add records to a sorted or filtered selection

and sometimes its hard to unsort it back to the default

Thank you for the quick reply and your response makes sense.

I'll just sort it how it should look and leave it at that.