FIltering subreports

  • Thread starter Thread starter Paul
  • Start date Start date
P

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???
 
It is easiest to add criteria to the subreports' record sources. These
criteria should reference controls on an open form.
 
Back
Top