Link to home
Start Free TrialLog in
Avatar of SteveL13
SteveL13Flag for United States of America

asked on

Filter a form when typing in a text box

I'm trying to filer records being displayed in a form when the user types in a text box.  This what I have in the onchange event of the form but if I try to type "123" as an example, it replaces the "1" with a "2" when I type the "2".

I also want it to display ALL records that contain "123" in the street address.

    Me.Filter = "StreetAddress like '" & Me.txtFindStreetAddress.Text & "*'"
    Me.FilterOn = True
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

use the onchange your input and filter your data with LIKE
Avatar of SteveL13


I don't understand.  I am using the onchange event but it isn't working as I stated.
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I went with a command button per you suggestion.  Thank you.