Changing a query with a radio button

[Courtman]

Hi all

Can someone advise if this is possible and how I would do it please - I'm going round in circles trying to sort this little problem out!

I have a form which posts the results of a query. The results of the query are in a subform, and on the main form are three radio buttons which allow the user to select how the results are sorted. Each different method of sorting is in a different query, either "Name", "Date" or "Number". When the user selects a different sort method, the query updates in the subform...

Thanks!

 

[FoFa]

Can't you just use the subform sort property and refresh the subform?