docmd

R

rodchar

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
 
A

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"
 
R

rodchar

thank you.

Allen Browne said:
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"
Click to expand...
 
Top