Anybody out there know how to use filter method to filter the records in the database??

Here is my situation: I am trying to filter out the certain records in the Access table1 by using two forms. Form1 contains a text box and a command button, form2 contains all the text boxes that are already bound to table1. The object is to filter the record(s) based on the entry in the form1's text box and use it to populate form2.

Again form2 is presently containing ALL the records in table1 as it is bound to it. How do we get it to be totally unbound and then get it to populate ONLY the records that filtered and then rebind itself after our needs are finished.

I am using ADODC as a conection to the Access database.

Thanks.