Search results to display in subform

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

Guest

I want to create a search form where there are unbound text fields (search in
one or more fields) in the Form Header, with the subform in Details. I would
like to display the fields in the subform. I would also like there to be an
option to create a report... I'm a Beginner/Novice at coding...

Any help would be appreciated.
Thanks.
 
Here's a sample database for you to download and see how it works:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

It is a matter of setting the Filter of the form. To print the records, you
can use the same filter string as the WhereCondition for OpenReport.
 
Allen,
Thanks for the quick reply. I am utilizing your information, however, the
results are not appearing in the detailed section of the form. It still shows
the entire database. When I don't put anything in any of the fields, it tells
me I have No Search Criteria.

What line(s) of code are instructing the search results to appear in the
Details area?

Let me know.

Thanks.
 
When you click the Filter button (top one on the right), its Click event
procedure sets the Filter of the form. Then the form shows only records
matching the filter.

But the code must be running or you would not get the message that there's
no criteria. Perhaps you have not adapted the code so that it uses names
that match your search boxes?
 
Back
Top