Modules & VBA :: How To Save A Form Filter To Reapply Later

I've taken over the running of the front end of an access database. It's old and antiquated, but is owned by our client and they don't want to move away from it. (it's probably worth pointing out I'm new to VBA, and not a programmer).

Most of what the users want in stored in one table which has a front end form. The users spend a lot of time setting up filters on the form (approx 20 different boxes to filter on).

I've been asked to add in a way of saving these filters so they can be recalled, and I'm wondering if there is an easy way of doing this?

I know that when a filter is set on a form that this creates a temporary query. So my thinking was to somehow save the SQL from the temp query to a new table (user can set a name for the filter from a subform when saving).

I was then hoping I could populate the sub form with a combobox (filtered on the logged in user) and display the appropriate items from the table.

The user could then select an item from the list, press apply, and the form would then be filtered using the previously saved query.