Hi,
I'm trying to filter a listbox with a query Rowsource through a textbox:
filter code:
Code:
"....WHERE (((tb15_Securities.tb15_NiarID) Like [forms]![formDefineEquity]![txtSearch] & "*")); "
So I'm using a change event for the textbox to requery the listbox, but the problem is that the change event fires up before there's a value in it.
(not like in Excel when the change event works after there's a value)
The only way that I've managed to do so is to use the 'after_update' event - but it's cumbersome, because I want the filter to work dynamically :
I.E. - whenever the textbox changes so will the the listbox without having to press the tab key.
Is there a solution?
Thank you!