Remove filter after query on form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I finally figured out how to build a search form that runs a query and lists
the possible records below. The user then double clicks on the record they
want to view and is taken to the main form (the search form then closes as it
is quite big and they may be on the record for awhile).

Now the database is filtered and you can only view that one record, unless
you open the Search Form again (which you may want to do) or remove the
filter. I would like to create a button on my form to remove the filter. I
tried adding a command button (apply filter) but that doesn't seem to work.
Any ideas?

Thanks in advance!
 
Hi Carrie

All your button needs to do is turn the filter off:
Me.FilterOn = False

You might also like to experiment with making the search form invisible
instead of closing it. That way, is the user wants to refine the search,
the form will be in the same state as it was left when it was last used.
Don't forget to have the main form's Unload event close the search form if
it is open.
 
Back
Top