Hi, Plz note, My VBA is disabled at work for security reason.
I can use only Expression builder, Macros, Queries, Tables, Forms and Reports only.
1.For example, if I make any filter in that table and I like it and I want to save it as Favorite, I click on the save filter button then I can put name for that filter and his criteria saved automatically and then it will show up in my Favorite filter in drop down list (combobox). and then I can chose which filter I like from the list and run it after update
2.and I want each user can make his own Favorite filter by himself and manage them to keep them or delete them etc..
How can I do it, because it is going to save time to me by making favorite filters
Plz Help!
I can use only Expression builder, Macros, Queries, Tables, Forms and Reports only.
1.For example, if I make any filter in that table and I like it and I want to save it as Favorite, I click on the save filter button then I can put name for that filter and his criteria saved automatically and then it will show up in my Favorite filter in drop down list (combobox). and then I can chose which filter I like from the list and run it after update
2.and I want each user can make his own Favorite filter by himself and manage them to keep them or delete them etc..
How can I do it, because it is going to save time to me by making favorite filters
Plz Help!