Forum Discussion
Lookup Wizard Search
By default, the Lookup Wizard only searches for values that start with the text I type in the field where I applied Lookup Wizard. But I want to search for any part of the list by typing in the field. For example, if I type in "Arab" in the field, it should return all the values in the list that contain the letters "Saudi Arabia", "United Arab Emirates" etc.. Can anyone help in this..
2 Replies
Kali12 Here's a video that might help you with this:
Search Button: https://599cd.com/SearchButton
This may also be of help:
Multi-Field Find: https://599cd.com/MultipleFieldFind
What you need is called a "Contains" search. It can't be implement in a standard Access combo box. The Lookup Wizard only sets up combo boxes, so you'll need to go about this differently.
