How do I specify ControlName for SetFilter

[mdavid]

Been trying for hours to get this right:

DoCmd.SetFilter (WhereCondition:="[Complaint] LIKE '*" & [txtFilter] & "*'", ControlName:="BercComplaintsSF")

I get Compile Error "Expected: ="

The problem is with the ControlName part, without that works ok. - Googled it couldn't find any examples of ControlName being used.

Decided to try a different route, but would very much like to know what the correct syntax is.

Thanks
David

[CJ_London]

I don't use docmd.setfilter but including brackets means it is trying to return something. The example provided here, does not use brackets, so why are you?

https://msdn.microsoft.com/en-us/vba...or=-2147217396

otherwise just use

me.BercComplaintsSF.form.filter="[Complaint] LIKE '*" & [txtFilter] & "*'"
me.BercComplaintsSF.form.filteron=true