Hi
I am a very new user of Access. I have a rather simple database that includes two tables, one query, one report and one form.
My database
One table is named tblPortfolio and the other table is titled tblAccreditedTests
The tblPortfolio has two fields in it; one is the autonumber field (primary key) and a field titled "Type" which gives the type of equipment serviced by our service team.
The tblAccreditedTests table has four fields; one is the autonumber (primary key), a field named "Type" (same as in the tblPortfolio), a field named "TestNumber" which has a two or three digit number, and a field titled "TestName" which is a short text field that has a short description of a test we perform.
My Query (titled tblAccreditedTests Query) is based off tblAccreditedTests.
I have one Report titled "tblAccreditedTests" Query which houses all relevant tests for all the equipment we service. It is around 220 pages long.
I have one Form titled "AccreditedTestSearch". On this form I have a combo box (Combo0) which is populated from tblPortfolio. The Combobox populates as I would expect it to populate.
I added a command button (Command6) which opens the Report tblAccreditedTests Query.
My Goal
What I want to do is to have the end user use the combo box to choose the instrument they want to test then press the command button. Then I want the report to be filtered to just those tests that are relevant to that particular instrument.
My Problem
I've tried everything I can think of to filter my report but to no avail. I imagine this is a fairly simple task but no matter what I do, I don't get a filtered report. I have stripped my database of my efforts in hopes that someone here can direct me how to create this simple filter command.
Thanks in advance for your help.
Patrick