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 event..read your input and filter your data with LIKE
Avatar of SteveL13

ASKER

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

Link to home
membership
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.