Using a Form to Filter a Report

[Chip]

Hello, I am relatively now to ACCESS so please be gentle with the VB...

I am wanting to have a Form that has 2 combo boxes that i want the user to
select a record for each one then the person hit a Print button and the
Report be filters by the 2 selections from the form.

Basically what i have is a single table that has information about students
in college and i want to build an easy user interface so that if they want a
list of the Seniors that are Majoring in Pre-med. Then the user will select
Senior from the "Class" Combo box and then select Pre-Med from the "Major"
Combo box. then the report that is printed will only show the Students that
are a Senior and Majoring in Pre-Med.

There may be a better way if there please let me know. AS ALWAYS, THANKS IN
ADVANCE!!!!
-Chip-

 

[Reggie]

Chip, you could base your report on a query. Add all the fields for your
report to the query grid. In the criteria row under the fields you are
filtering use the values of the combo boxes.

Under major field:
=Forms!MyFormName!MyMajorCombo

Under class field:
=Forms!MyFormName!MyClassCombo