Search using unbound text box and change record source

[Lordoasis]

I will appreciate some assistance with a project of mine. I am relatively new to access.
I have a form with unbound text boxes. I want to be able to search for member IDs with one of the unbound text boxes as the source of the search criteria and then the result should be displayed on the same form.
After this is done, i will like the record source to be changed to another table so i can add some data to the ones displayed by the search criteria before adding to the new record source.
I will appreciate some VBA assistance with this. Your directions as to what to do will also be appreciated.
Thank you

[NeoPa]

It seems to me your whole requirement can be handled with some simple filtering. See Example Filtering on a Form.