Can I use "Filter By Form" to build a neat search form?

  • Thread starter Thread starter Chrisso
  • Start date Start date
C

Chrisso

Hi All

I would like to have a form that helps users search a table or query.

I would like to have the top of the form list the fields.

The bottom of the form will be a subform or listbox that lists the
matching results.

Can I use Access's "Filter By Form" facilitiy to achieve this? That
is, can I make the top part of my form always look like the search
form you see when filtering by form? And can I make the bottom part
(subform or listbox) always show the resuls of filtering by the form
above? I like the "filter by form" faciliity but I want to split it
out into its two parts to make it easier for the user to understand
how they are searching and for them to further refine their search.

Thanks for any cluses/ideas/links in advance,
Chrisso
 
You can't make the built-in Filter By Form look like that, but you can
program your own.

Here's a downloadable example of how it's done:
    Search form - Handle many optional criteria
at:
   http://allenbrowne.com/ser-62.html

--
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.











- Show quoted text -
Click to expand...

Thanks Allen.

Great site - I have used it already in the past.

Chrisso
 
You can't make the built-in Filter By Form look like that, but you can
program your own.

Here's a downloadable example of how it's done:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.











- Show quoted text -
Click to expand...

Thanks Allen.

Great site - I have used it already in the past.

Chrisso
 
Back
Top