Hi. I need a little help with a 2010 Access database. It is a very basic database; it has a pop up form with criteria controls at the top, a subform form below that displays the query and a smaller subform to the right that displays detailed results. I have it near complete but I need 2 things added that I am having trouble with:
1) I need to allow users to save query strings and be able to load them latter. I do not want users to actually export the table data so I would rather allow them to save the exact query string.
2) I need to be able to allow users to preform a "add" and "remove" search by button. This means they need to be able to change the criteria and run a query that would "add" or "remove" to the existing query. Like this:
My table values: 1 2 3 4 5
User "search" queries: 1,2
Subform displays query as: 1,2
User "add" searches: 3,4
Subform displays query as: 1,2,3,4
User "remove" searches:2,3
Subform displays query as: 1,4
If you be able to do this, please let me know if you can and how long you think it would take.