I have not done any access work in a lot of years and I cannot figure out my current problem.
1. I have a single table database that has 30 columns.
2. I am creating reports to extract certain data from
the records.
3. None of the records have all of the fields filled
in.
4. I have created queries for each type of report that
I need. All of the queries work but they all return
there data from all of the records in the database.
5. I have created Reports for all of the queries. All
of the reports work but the reports also contain
data from all of the records in the database.
6. I have created a form that contains Combo boxes
(1 for each report). My intent is to select the
data I need in the report based on the text
contained in the combo box. The combo boxes are set
up to pull only unique values from the table because
many of the values are duplicates. They are also
set up to "Limit to List" so that only information
entered into the table is available for selection.
This function also works correctly.
7. Each Combo Box has a command button that is supposed
to execute the querie, based on the text contained
in the combo box. The querie should retrieve the
information from only the records that contain the
combo box criteria and send that information to the
report.
8. I need help figuring out how to get just the
information that I want from the querie and then
getting the querie to send it to the report.
9. Note: I can make it work correctly by having the
querie ask for the search criteria but this database
has over three thousand records. That is why I
want to use a combo box and be able to start typing
and let the combo box narrow down my search for the
correct search criteria.
10. Note: I have found numerous pieces of code online
that showed promise but none of them have worked
out. Any help would be greatly APPRECIATED ! ! ! !
Thanks
wgreen