Hi
I'm trying to perform a query where by I type information into a text box, the Query performs a search on the text box and the query is displayed on a sub form.
My first problem was when ever I refreshed the form i lost the data that I queried so I created a form for Variables, so that I could query those! That acted as a solution but maybe not the best one!!!
My second problem the main one was that I wanted to improve the query so that each time I input another letter into the text box the sub form would drill down through the data. I type C then followed the C with an O and it narrowed the search to COB, hopefully you can get my drift.
Any help will be much aprreciated.
Thanks in advance
COB
I'm trying to perform a query where by I type information into a text box, the Query performs a search on the text box and the query is displayed on a sub form.
My first problem was when ever I refreshed the form i lost the data that I queried so I created a form for Variables, so that I could query those! That acted as a solution but maybe not the best one!!!
My second problem the main one was that I wanted to improve the query so that each time I input another letter into the text box the sub form would drill down through the data. I type C then followed the C with an O and it narrowed the search to COB, hopefully you can get my drift.
Any help will be much aprreciated.
Thanks in advance
COB
