VBA, Apply Filter
Posted on 2001-06-11
I have this annoying thing that I can't solve. I want to apply a filter (afterupdate a combo box), but it doesnot seems to work.
This is what I have:
DoCmd.ApplyFilter , "[Segment] = " & Forms!SalesfunnelSegment.Segment And "[LeadLaf].[Code] = " & Forms!LeadsLaf.Code
The error message is "Type Mismatch"
However this works:
DoCmd.ApplyFilter , "[Segment]='" & Forms!SalesfunnelSegment.Segment & "'"
It seems that I can't ask to filter on two fields, which I think should be possible.
Thx in advance.