Hi
I have a form with a list box showing a lot of records. I have set up a text box to enter start of field data to requery the list box and reduce the matches. I can get this to work fine with a seperate button with a requery macro on the OnClick event. But is there anyway that I can get the list box to requery as the data is typed into the text box? - like the old help files in MS Office.
I tried putting the requery macro in the On Change event of the text box, but it doesnt work, as I think it has to lose focus to register the data. Also tried some of the other possible events with no luck.
Any advice greatly appreciated.
Thanks
Rich
I have a form with a list box showing a lot of records. I have set up a text box to enter start of field data to requery the list box and reduce the matches. I can get this to work fine with a seperate button with a requery macro on the OnClick event. But is there anyway that I can get the list box to requery as the data is typed into the text box? - like the old help files in MS Office.
I tried putting the requery macro in the On Change event of the text box, but it doesnt work, as I think it has to lose focus to register the data. Also tried some of the other possible events with no luck.
Any advice greatly appreciated.
Thanks
Rich