hello,
i just found this topic as i was lookignf or a search form too. This isnt the idea i had had, but it works perfectly and ive been able to use it and implement it into my own database (for instance, ive got multiple text boxes and commands searching for the different fields in the table).
My only problem is this: you do a search, the majority of records disappear. to get them back you need to close the form and open again. Is there anyway i can make a button that when pressed will 'refresh' the data. IE, make it so that it has all the records again, just like when you first open the form?
thanks alot.