Using one search button to look in four forms?

[Ledmark]

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

[JustJim]

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