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

Using one search button to look in four forms?

P: 19
I have a database that uses four forms and each form has it's own table and each form has it's own search button to find a specific record within that table. I would like to use one search button that will look at all four tables and bring up the correct record when the request number is entered. Can I link all the tables to perform this or is code required? Can someone send me in the right direction for how to do this? Give me an example of code if it's required?

Thanks for any help someone can give me.

Laura Edmark
Mar 10 '08 #1
Share this Question
Share on Google+
1 Reply

JustJim
Expert 100+
P: 407
I have a database that uses four forms and each form has it's own table and each form has it's own search button to find a specific record within that table. I would like to use one search button that will look at all four tables and bring up the correct record when the request number is entered. Can I link all the tables to perform this or is code required? Can someone send me in the right direction for how to do this? Give me an example of code if it's required?

Thanks for any help someone can give me.

Laura Edmark
Hi Laura
If you can write a query using query design to bring up just the record(s) that you need from all four tables, then you can design a form based on that query and use a search button to search and display from that query. Whether or not that form/query is updateable (ie you can change the data in the underlying tables) depends on the design of the query though.

Have fun

Jim
Mar 20 '08 #2

Post your reply

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