Filter only Subform

  • Thread starter Thread starter David W
  • Start date Start date
D

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?
 
David said:
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
Click to expand...


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
 
Back
Top