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.
3
