How can I use a text box to search a list box

By kfraone ·
I am using a parameter form with a phone index and list box. the phone index concept is used because the recordset we use for the listbox, which provides criteria for our reports, is around 300,000 unique entries. The sql for the list box includes the criteria that allows the phone index to requery the listbox for the proper alpha character. The end-user prefers to type in the first few characters of the name and have it select the record in the listbox. I have included Microsofts basSearch module and implemented all code. It will not work with the paramter criteria in the listbox's record source. works fine without that piece, but as explained above is necessary. I am not a programmer, and need help trying to modify the code so both will work together.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums