Filter box for split form

[Tskutnik]

Easy one for anyone out there with skills... not me obviously.

I need to filter a split form, including wildcards.

Preferably I add a text box in the non-datasheet section, and the user types the string they are searching for. The datasheet then is filtered to just those rows that contain the text ANYWHERE in the field (something like: Like "*"&[FilterValue]&"*"

Text Box where the filter value is typed = [filterval]
The text field begin filtered = [skill name]

When the user blanks out [filterval] it should remove the filter

If [filterval] = "Dog" the [skill name] records should include

My Dog
Her Dog
Dog
Dog Catcher

Thanks very much for your help
Tony

 

[Ranman256]

Sub TxtFilter_afterupdate()
If isnull(txtfilter) then
      Me.filterOn = false
Else
    Me.filter="[field] like '*" & txtFilter & "*'"
    Me.filterOn = true
End if 
End sub

 

[Tskutnik]

Perfect. Thank you very very much