FIltering subreports

[Paul]

I have a master report (just an unbound frame) with 4
subreports on it. I need to generate a master report from
multiple variables (username, date-in, date-out, product-
type, etc...).

I have the subreports based on queries that keep track of
constant information (date-in, date-out) but NOT the
random variables (username, product-type, etc...). I made
a simple function to generate a filter that could be
applied to the subreports at the "onopen" event. This
works great opening the subreports by themselves (using
the Me.Filter = (my filtername) but will not work when I
try to open the master report.

I get the error message "Run time error 438" "Object
doesn't support this property or method".

This is an Access 2000 database.

Anyone have any ideas???

 

[Duane Hookom]

It is easiest to add criteria to the subreports' record sources. These
criteria should reference controls on an open form.