Search form results open in report view instead of subform

[imelda1ab]

I am an access baby still cutting my teeth. I'm working on a database
for some librarians and have a simple form containing 6 fields for
them to use to search for material. Currently, I have the search
results appear in the subform and the user clicks "Print Results" to
get the pretty report. They don't like the subform results. They
want the report to show as a result of the search, not the subform.
Can this be done? Is it a simple macro and I'm overthinking the
process? Also, they want a field in addition to those contained in
the table that will search across all of the fields in case they can't
remember whether the word is part of a title, abstract, descriptors,
etc. I don't know what I'm doing and I've googled everything I can
think of and obviously can't word my question(s) succinctly enough.

Any help is much appreciated.

 

[pietlinden]

I am an access baby still cutting my teeth. I'm working on a database
for some librarians and have a simple form containing 6 fields for
them to use to search for material. Currently, I have the search
results appear in the subform and the user clicks "Print Results" to
get the pretty report. They don't like the subform results. They
want the report to show as a result of the search, not the subform.
Can this be done? Is it a simple macro and I'm overthinking the
process? Also, they want a field in addition to those contained in
the table that will search across all of the fields in case they can't
remember whether the word is part of a title, abstract, descriptors,
etc. I don't know what I'm doing and I've googled everything I can
think of and obviously can't word my question(s) succinctly enough.

Any help is much appreciated.

If you base the report on an unfiltered query, you can then pass the
filters on the open event of the report. Just build the filter in a
string variable...