Use a textbox to requery a bound listbox

[jeffmoseler]

I have a bound Parent form with a Bound Listbox that navigates the form to a certain record.

I would like to be able to filter the Listbox with a "search" text box to make it easier to find the records I need to update with the child subforms.

I thought it would look something like this:

SELECT tblLeads.DotNo, tblLeads.LegalName
FROM tblLeads
WHERE (((tblLeads.LegalName) Like "*Forms!frmContactHistory!Text26*"))
ORDER BY tblLeads.LegalName;

But I think I am running into an issue because the form and the listbox are bound to fields in the table. Is there a creative way around this or do I have to unbind the form and listbox?

 

[jeffmoseler]

bump

 

[xenou]

A listbox can be bound but have a recordsource that isn't the same as the underlying table/query. It's just the value of the listbox (selected value) that is the "bound" value, not the entire list of records displayed.

I don't use search boxes a lot - Access has a lot of built-in filter features that I find extremely powerful without having to do anything special at all.
This might help (but it's all I know about to suggest):
http://www.allenbrowne.com/ser-03.html