By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 1,057 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

Search using unbound text box and change record source

P: 1
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
Dec 28 '11 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,494
It seems to me your whole requirement can be handled with some simple filtering. See Example Filtering on a Form.
Dec 28 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.