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

[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

 

[sanfillippo.alain]

"Chrisso" <[email protected]> a écrit dans le message de groupe de
discussion :
(e-mail address removed)...

 

[Allen Browne]

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

 

[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 -

Thanks Allen.

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

Chrisso

 

[o;;]

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 -

Thanks Allen.

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

Chrisso