use a table of reports and a filter form to run reports

[kpal29]

I have a table that lists reports

I have a form that has comboboxes that are used as criteria for the queries underlying the reports

I have added the table of reports as a sub-form to my criteria form.

I have a button on the form.

I would like to select a record from the subform table that will open the report selected.

I know I need some varitm VB...

 

[jrbarnett]

Working on the assumption that this is Access VBA rather than a table in Word, it will (if I understand you correctly)

DoCmd.OpenReport frmCriteria.Form!sfrmReports.cboReportlist.Value, acViewPreview, Whereclause:="Field='" & me.cboCombo1 & "'"

Basically
- the first parameter is the control on the subform with the report name
- The second is the constant to tell it to open in print preview mode (or it will come out of your printer)
- the third is a where clause based on one of the combo boxes

You will need to change the controls to those in your application.

John