Multiple sources for query

[Listerman]

I'm using two forms to open a report. One form contains the Supervisor and Month. The other form is user specific information.

Criteria currently using:
Forms![frmScorecards]![Month] or Forms![frmUser]![Month]

Now when i run the report from frmScorecards it asks for the parameters of FrmUser!Month.

Id like it to look only at frmScorescards!Month cause its the active form.

Thanks in advance.

 

[boblarson]

You can't do it the way you're trying to do, but it is easy to, when you open the report you assign the filter at that time:

DoCmd.OpenReport "YourReportName", acViewPreview,,"[FieldNameHere]='" & Forms!frmUser.[Month] & "'"

Now, you really should not have MONTH as a field name or object name because that is an Access Reserved word and will only cause you pain and suffering when you least expect it. {smee - hee}