Re-sorting a query in a form

[Courtman]

I've posted this on the Forms queries, and duped it here just in case....

I have a form which contains a sub-form with the results of a query. I would like to add an option box which allows the user to re-sort the query by different columns.

The options would be:

SORT BY:

• Airfield Name (default)
• Date of First Visit
• No. of Visits

...and this would re-sort the sub-form.

Can anyone help with this?

 

[llkhoutx]

On the AfterUpdate event of the option box reset the sql string which is the recordsource for you subform to sort by the appropriate field..