Search for multiple records and print them to a report

[topotoole]

I want to search a database by typing in the word/number I am looking for, then display any records associated with it; then I want to print only those records out in a report template.

For example, in Access 2007, from a table I can select the down arrow from the column header to go to filters, then selecting "Text Filter" and then "Equals..." I can type in what I am looking for. It displays all the records associated with what I searched. But, instead I want the ability to select a button that takes me directly to where I enter in what I am searching for. Then I want another button that takes me to a print preview screen displaying a report listing all the records associated with that search.

I appreciate any assistance you can provide.

[zmbd]

Queries are your friend.
Forms and VBA are your tools.
Reports are your final product.

Normally, I would simply delete your thread; however, I also don't want to discourage you from participating in the forum.
So, with that in mind, Bytes is not a code nor homework service; however, if you already have code or SQL in the works and it isn't performing as expected then we can usually help.

Please read the FAQ and posting guidelines:
>> Before Posting (VBA or SQL) Code.
>> How to ask "good" questions -- READ BEFORE SUBMITTING A QUESTION!.
>> POSTING_GUIDELI NES: Please Read Carefully Before Posting to a Forum.

[topotoole]

Got it; your condescending attitude is noted. I didn't read the FAQ. I did an internet search and arrived at this forum. So I simply posed a question for something I am working on. But I do appreciate your quick, yet smug reply.

Rest assured, I certainly will not be knocking on this forum's door again. Consider me "discourage d".

Queries are your friend.
Forms and VBA are your tools.
Reports are your final product.

Normally, I would simply delete your thread; however, I also don't want to discourage you from participating in the forum.
So, with that in mind, Bytes is not a code nor homework service; however, if you already have code or SQL in the works and it isn't performing as expected then we can usually help.

Please read the FAQ and posting guidelines:
>> Before Posting (VBA or SQL) Code.
>> How to ask "good" questions -- READ BEFORE SUBMITTING A QUESTION!.
>> POSTING_GUIDELI NES: Please Read Carefully Before Posting to a Forum.

[zmbd]

Topotoole,

First, An apology; I had not intended to be "smug" or condescending; however, I can see how you might take it so.
From your post:

(Topotoole) I want to search a database by typing in the word/number I am looking for, then display any records associated with it; then I want to print only those records out in a report template. ( …)

In what way did my reply not answer your question:

(zmbd) Queries are your friend.
Forms and VBA are your tools.
Reports are your final product. ( …)

Your question is fundamental to the nature of what databases are designed to do – store, find, and report data. You query the data using either a parameter via the query itself or a form and either display the results in a form first or take it directly to a report. What you appear to be asking us to do here is blindly build you a generic project – that will not happen. Out right requests for full code are against site policy - Bytes is neither a code writing nor homework service. Which if you had read the FAQ and posting guidelines before posting your question you would have known.

Following (which show up in Google searches BTW)may help and there are ton of guides if you will scroll down to the bottom of this page and click on the insights site map (or click on the insights tab at top):
-filtering-
Microsoft Access / VBA Insights Sitemap
42.Cascaded Form Filtering
55.Multiple Combobox Filter with Clear Option
168.Example Filtering on a Form.

As for the remainder of your reply:
The tone is/was that of an angry child. Even if you didn’t like the response you received, something along the lines of: “Yes, I understand that; however, your reply is less than helpful to me as I have no background in database design or development.”

The mere fact that your “first” post went straight to forum without prior review shows our faith in new member’s abilities to read and understand the requirements for participating in this site and the expectation that new members will be able to ask a properly worded question.
Almost as important as a well worded question is that when confronted by an undesired reply by site moderator or one of the designated experts the member will respond as an adult/peer – not stamp their foot as a three-year-old and start name calling.
Failing/refusing to read a site’s posting guidelines and FAQ prior to posting anything is simply poor manners in this day and age – frankly, it is inexcusable unless you are over 65 and even then barely so… even my 85 year old neighbor knew enough to read thru the posting requirements and guidelines before posting on the forums he has joined.... then again... he comes from an age when respect for your peers, friends, teachers, and others was the norm and not the exception.

[topotoole]

Noted. Thanks for the lesson and the information.

[zmbd]

You're most welcome.
As tends to happen to best of us, as you hit the snags building your queries, forms, and reports please post back. Site requirements are that new questions are in their own thread.
Some things to keep in mind when posting:
Tables, if you will provide the table name(s), (the field name, data type, if it is a primary key, indexed, linked to other tables)
With the Queries, posting the actual SQL used is preferred over text - easily cut and paste from the SQL view of the query designer.
Forms, Controls are the parts of your forms/reports which are different from fields that are in your record sets. Controls are either bound to a field in the record source for the form/report (or the record-source for the control itself). It helps to have the naming conventions clear when posting a question.

best of luck