DoCmd.ApplyFilter with wild card

[cksm4]

Hello,



Still new at this so this may sound basic...

I need to filter a column on a split form based on matching text using a wild card search. I am unsuccessfully attempting to use this code:

If Me.CboShowMe = "Pending Items" Then
DoCmd.ApplyFilter , ActivityType Like "Pending*"

The field ActivityType can contain multiple values beginning with "Pending". I want to show all these values when "Pending Items" is selected from the CboShowMe combo box.

Help is GREATLY appreciated!

[weekend00]

I think it should be:
DoCmd.ApplyFilter , "ActivityType Like 'Pending*' "

[cksm4]

Thanks! Using...

DoCmd.ApplyFilter , "[ActivityType] Like 'Pending*' "

...worked. Without the brackets it asked for parameters. But this got me where I needed!!

[weekend00]

sometime always tiny things make us crazy.