>>>I am looking for better logic to my input statement.
>>>I have 10 input boxes representing 10 diff fields which the user enters values into as many as he likes to narrow down his search.
>>>the more textboxes filled out, themore narrow his search becomes.
>>>Then I must set a filter using my screwy logic unless someone has a good idea for me.
>>>Thank you !
>>
>>I have a procurement status system that does just that. There are 18 fields to filter on. So what I did was set up a view and have a parameter for each possible field that would be entered. They are all character fields so I would initialize the parameters in the form to "". Then if the user entered data into a filter field then the parameter would be set, if they did not then a "" parameter matches all records. I found this to be a slick solution to the query screen that requires many fields to be entered. The view would bring back all the records filtered on what the user entered. HTH
>
>Brett, What I need to do is isolate the records into a cursor or table and work with them from there.

My solution isolates the query into a view that I work with, it is updateable and indexed. So I guess I dont understand the question.