Generating Reports

[jj1]

The input form of the database have one common table containing data for all parameters for row source. As all data was in one table had one ID. My problem is I am trying to run reports from a form after selecting dates and parameters.For selecting parameters I created dynamic combo box. For dynamic combo box I needed ID and description of the parameters. So I created separate tables for each parameter with ID and Description column. Which ran me into the problem that when I run report based on main input form which has different row source table and my report form has different row source tables and reports doesn't run when I base my queries on the report form.

[ranman256]

I dont understand the question without detail....to run reports from a form where the form has the criteria...

user picks items in a combo or text box so the report query has

select * from table where [state] = '" & forms!frmMyForm!cboState & "'"

[jj1]

Yes That's right. However my combo boxes were required to be dynamic combo boxes. For these comboxes I created new tables instead of using old common data table. Thus my row source for main input form is different than report form. I hope I am making something clear.