Being able to retrieve a previous filter on a form

[john.constantine]

Lets say I have a query as the forms record source I do some
filtering of the form then close the form.
Is there anyway to save the forms previous query or be able to retieve
it
Say I have done some complex sorting and filtering close the data base
comeback the next day and want to display the last query I was working
on

 

[Allen Browne]

Sometimes the form filter is saved (e.g. if you switch to design view), but
the only safe way to do it would be to write its Filter property into a
table in the form's Unload event, and then read it from there again in the
form's Load event.

You could even set up the table to hold multiple filters for each form, each
with a name/description the user gives them if you wish.