We help IT Professionals succeed at work.

Access use text box to filter form data as user types

Murray Brown
Murray Brown used Ask the Experts™
on
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

1
2
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
NoahHardware Tester and Debugger

Commented:
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
Senior Developer
Commented:
You need to select the "form" itself, by clicking on the left-top corner:

Capture.PNG
Then you can access the forms Record Source property.
Mark EdwardsChief Technology Officer

Commented:
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.
Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
Thanks. That is exactly what I needed