Need help understanding a line of code.

[coilerDH]

I am working on a DB that I did not create. I am not understanding a line of code and could use some input.
DoCmd.OpenReport "Monthly Reports Due", acViewPreview, , IIf(subMonthlyReportsDue.Form.FilterOn, subMonthlyReportsDue.Form.Filter, "")


IIf(subMonthlyReportsDue.Form.FilterOn, subMonthlyReportsDue.Form.Filter, "") this part is where I m not completely sure what it is saying. I don't know if this requires more background on the project to give an explanation.
Thanks.

[June7]

It's an IIf conditional expression. It is setting the report WHERE condition argument based on the form filter. An IIf() has the follow syntax:

IIf(expression that evaluates to true or false, do this if expression is true, do this if expression is false)

FilterOn property is either True or False.

IF form FilterOn property is True THEN use expression from the form Filter property ELSE use empty string.

[coilerDH]

If I try and duplicate this in my own DB it does not pass the text filter from the form into the report. That is what this is doing in the DB that I am working. To help me understand what is going on I tried to recreate that functionality in a new DB. What other way can I pass in the text filter to the report using the OpenReport method?
The stuff I have seen is like this:
DoCmd.OpenReport "Sales Report", acViewNormal, "Report Filter"

but the text filter from the data grid view of the report is not a "pre defined" filter.

[June7]

That example code is setting the FILTER argument, not the WHERE CONDITION argument. I have never used FILTER argument.

If the form Filter property is not used to dynamically filter the form then certainly there is nothing to pass to report.

Normally I pass a value from a field or control on the form.

DoCmd.OpenReport "report name", , , "ID=" & Me.tbxID