Where to start: user defined reports

[noweyout]

I have a report similar to a Class roster. My goal is to have the user select which class to print a report on, since there are multiple classes. Currently, I have it where the report shows all the classes and a list of students in that class.

Here's my idea:



I will have a command button which will bring up a small form with a combo box to select which class you want to view.

Is it as easy as using the properties to do this for me? Maybe create a select statement and have it point to the combo box for a value? Any ideas?

[RuralGuy]

Just use the ComboBox to place a WhereCondition Clause in the OpenReport command.

[blazerboy6]

I've got several forms like this built to launch reports. Create an unbound combo box on the form which displays the class names and call it cboClassName.

Assuming your form name is frmSelectClass, and the field name for class is [clClassName], add the following to the criteria for the "Class Name" field (ie. [clClassName]) within the forms query builder
(click three dots on the side of the Record Source Property in Design View on the Report to get to this):


IIf(IsNull([Forms]![frmSelectClass]![cboClassName]),[clClassName],[Forms]![frmSelectClass]![cboClassName])

Add a cmd button to launch the Report next to it and you should be set.

This will filter the report for the selected class, or if no class is selected, give you a report with all of them.

Hope this helps,