filter subform by character (button)

[pinstripe]

Hello,
i wuold like to filter subform by a character in specific field - in field [Item Type] have values "S","C" or empty
my code so far:

Me.[Equip-Stock Code from Work Orders subform1].Form.Filter = "[Item Type] = S"
Me.[Equip-Stock Code from Work Orders subform1].Form.FilterOn = True

But when i press the button it give's me a pop up screen where i need to write "S" -Ok .. and then it does the job
i would like just to press a button and VOILA!!

can anyone help me please???

 

[PaulF]

try delimiting the values
use 'S' instead of S
"[Item Type] = 'S'"

PaulF

 

[pinstripe]

thank you -- it worked superb