accessing the 'filter' property of a subform

  • Thread starter Thread starter Brad Pears
  • Start date Start date
B

Brad Pears

I would like to reset the "filter" property of a subform I have on a tabbed
control. When I try to access that property I get an "object doesn't support
this property or method" error.

I am usign the following syntax to access the subforms filter property...

forms![purchasing]![purchasingitems-filtered].filter = "a filter expression"

.... where purchasingitems-filtered is the subform name.

Maybe you can't set the filter property?

Thanks,

Brad
 
forms![purchasing]![purchasingitems-filtered].FORM.filter = "a filter
expression"
or
ME![purchasingitems-filtered].FORM.filter =

BUT. DON'T DO IT :)

Using the filter on a subform is kind of flakey and difficult to predict.
For example, you may find that the filter has no effect at first: then locks
on when you move to a matching record.

Instead, use the link child/master property.

(david)
 
Back
Top