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
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
![1]()
![2]()
I use the following to filter a list box in the row source of the first image
Like "*" & [forms]
Microsoft Access
Last Comment
Murray Brown
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.
ASKER
Thanks. That is exactly what I needed
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