Want to save a Form Filter to reapply later

[tbdel]

Hi,

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.

Any help out there would be appreciated.
Tom

 

[namliam]

Hi,

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).

I am sorry but if it is a serious database that needs some TLC... why would someone without experience be tasked to look at this? :banghead:

Easiest way to accomplish this I think is it fetch the filter on the form and store it in a table.

Your users would give the filter a name which you can have display on a combobox like you suggested... Shouldnt be that hard to do though will needs some vba to save/retrieve/activate the filter

p.s. Welcome to the forum