I have a form with an unbound Listbox that finds a record on a form. When you select the Company Name, the two subforms show the records associated with the selected company name. The listbox contains thousands of companies. I would like to be able to enter text into a textbox that filters the Listbox wth any matches. I though about changing the Record Source of the List box to:
SELECT tblNavigatorLeads.DotNo, tblNavigatorLeads.LegalName
FROM tblNavigatorLeads
WHERE (((tblNavigatorLeads.LegalName) Like "*[forms]![frmContactHistory]![Text26]*"))
ORDER BY tblNavigatorLeads.LegalName;
It just makes the listbox go blank when I enter something into the text box. Any thoughts?
SELECT tblNavigatorLeads.DotNo, tblNavigatorLeads.LegalName
FROM tblNavigatorLeads
WHERE (((tblNavigatorLeads.LegalName) Like "*[forms]![frmContactHistory]![Text26]*"))
ORDER BY tblNavigatorLeads.LegalName;
It just makes the listbox go blank when I enter something into the text box. Any thoughts?