docmd

[Guest]

hey all,

i'm using docmd.openreport and i have a question about 1 of the parms:
FilterName

how do i use this parameter? i'd like to be able to open my report based on
whether a field is true or false.

thanks,
rodchar

 

[Allen Browne]

The FilterName is not really useful. Use the WhereCondition instead.

Example: if you want to open a report limited to only the records where the
Inactive field is false:
DoCmd.Openreport "Report1", acViewPreview, , "Inactive = False"

 

[Guest]

thank you.

The FilterName is not really useful. Use the WhereCondition instead.

Example: if you want to open a report limited to only the records where the
Inactive field is false:
DoCmd.Openreport "Report1", acViewPreview, , "Inactive = False"