Filter only Subform

[David W]

This may be easier

how do you filter a subform in VB

I tried this in a subform that is not linked and it didnt work
me.filter = [vendor] = me.combo45
me.filterOn = true

Ideals?

 

[Marshall Barton]

how do you filter a subform in VB

I tried this in a subform that is not linked and it didnt work
me.filter = [vendor] = me.combo45
me.filterOn = true

The filter property is a string valued property. The string
should contain the filter expression. Assuming that Vendor
is a text field:

me.filter = "[vendor] = """ & me.combo45 & """"

If it's a numeric type field:

me.filter = "[vendor] = " & me.combo45