Using a Drop-Down or Combo to filter for Report

  • Thread starter Thread starter Chip
  • Start date Start date
C

Chip

This is my first endeavor into a Report anything like this as I am very new
to ACCESS and can barely spell VB.

I am wanting to filter data to a report from a button that is pressed on a
form but i want the next box seen to have a dropdown or combo to select the
employee you want to see the data for in the report. I have tried looking
in all the books i can find on ACCESS but all i see is the use of the
'Brackets' for a input screen, but some of these people have very difficult
names to spell so it would look like the person had no data but they just
misspelled the name. A dropdown or combo is the only way i can see to make
sure the correct person ( and their correctly spelled name) is selected. If
i cannot use a dropdown or combo is there any suggestions? THANKS IN
ADVANCE!!!
 
it's hard to give you any advice without knowing what you
understand. do you know any SQL? do you know any VB? if
you plan on using access a lot in the future i would
suggest getting your hands dirty using both of these as
soon as you can. you can learn a lot from the help files.

the best/easiest way to do a report is to base the report
on a query. then all you have to do is change the query to
get different information on your report. if you have a
drop-down box that lists all the different last names in
the table, you need to be able to get the ID of the record
that the box has selected. then you can get at it in your
WHERE clause:

WHERE ID = somenumber;

in your current situation it might be easiest to simply
add a value to the WHERE Clause property of the report.

just remember that if you say WHERE LastName = "Smith" for
example, there might be hundreds of records where the
persons last name was smith. thats why you would want to
use an ID.
 
Back
Top