Link to home
Start Free TrialLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Access use text box to filter form data as user types

Hi
I use the following to filter a list box in the row source of the first image
Like "*" & [forms]![f_List_ActionType].[txtSearchActionType].[Text] & "*"
I now want to do something similar in a form shown in the second image. There is no rowsource
so how do I do I achieve something similar

User generated image
User generated image
Avatar of Noah
Noah
Flag of Singapore image

Hi there! :)

You may refer to the attached file for an interactive solution.
Example: FindAsUType2000.mdb

This link shows another example and has a step by step guide.
Reference: https://www.opengatesw.net/ms-access-tutorials/Access-Articles/Search-As-You-Type-Access.html
ASKER CERTIFIED SOLUTION
Avatar of ste5an
ste5an
Flag of Germany 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
say what? can't tell what you are wanting to do.  Need a little more description... and use rowsource or recordsource properly as the form has a recordsource, but there are no controls on the form that have a rowsource.
Avatar of Murray Brown

ASKER

Thanks. That is exactly what I needed