Combo box on for to preview report

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.
 
G

Guest

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top