Combo box on for to preview report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with two combo boxes; the first is a list of classes, the
second is a list of sections (1,2,3, etc.). I also have a command button
labelled "Preview Report".

When I select from both combo boxes and then click on the button, the report
runs, but it shows info from every class in the database. I cannot seem to
get the form to only preview one class.

Any suggestions? Thanks in advance.
 
Your record source in the report should point to the form for the criteria,
the criteria row in the record source query will look like:
Field Class
From YourTableName
Criteri [forms]![MyForm]![Mycombobox]
 
Back
Top