Private Sub txtsearch_afterupdate()
Me.Form.Filter = [Forms]![frmsearchrofile:active]![Last] Like [Forms]![frmsearch
rofile: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?