filter don't work?

[ck4794]

Private Sub txtsearch_afterupdate()


Me.Form.Filter = [Forms]![frmsearchrofile:active]![Last] Like [Forms]![frmsearchrofile:active]![txtSearch] & "*"
Me.FilterOn = True
End Sub

i've tried a million combinations of the above. at least it doesn't bring back an error. but it does do this. i type in "A" as i'm looking at the list of
A
B
A
Nothing happens
I type in "B"
and the filter yields no results.

Any Advice?

[ck4794]

s.o.b. i found the thread to answer my question after i posted this. just in case someone comes across this post instead of that one first, here was the correct answer:
Me.Filter = "Last LIKE '*" & Me.txtSearch & "*'"
Me.FilterOn = True

[pbaldy]

Try

Me.Form.Filter = "[Last] Like '" & [Forms]![frmsearchrofile:active]![txtSearch] & "*'"

[pbaldy]

Oops, looks like I type too slowly. By the way, the colons are not recommended. See symbols at the bottom:

http://support.microsoft.com/default...b;EN-US;209187