Subform with multiple parent forms

[mwc0914]

I have a series of forms that each execute a parameter driven query (each form perorms a different type of query on the same table). I want a common "output form" for each query result. I suspect the output form would be a linked subform. How do I link the subform to multiple parent query forms?
Or perhaps is there a better way to design this?

[orange]

Perhaps if you described to readers WHAT you are trying to do in business terms in plain English you may receive some responses with options. Maybe a sample with your data would help.

[mwc0914]

Ok, let's try this...

A. I have a form (Form A) where the user enters an airbill number. They click a button on the form that executes the query and returns all shipments with the entered the airbill number, country, and ship date. The results are displayed on a subform (Subform C) that is linked to the original form.
B. I also have another form (Form B) where the user enters the country and a button the user clicks to execute a query that returns all shipments with the same country (These are read from the same table as the earlier query). The query results are displayed on a subform (Subform C) that is linked to the original form.

So, if either A or B are executed, the results will display on Subform C, overlaying the previous query's results.
So, I have two parent forms, one for each query, and a single output form.

How is this set up?

How do I set up

[orange]

I think you are telling us HOW you do something (or plan to do something). Can you tell us in business terms WHAT you are trying to do?
(Forget the forms and buttons and queries)

[mwc0914]

There are two separate searches based on user entered criteria - one that looks up all the shipments with the same tracking number and a different one that looks up all the shipments for the same country.
The results for either search will display other than where the search criteria was entered for each search.
The location for the displayed results will be able to display either search's results.

[orange]

Ok I think I follow.

You want to perform 1 of 2 separate searches
Search 1 --Find shipment records based on TrackingNumber
Search 2 --Find shipment records based on Country

Display the found records in a standard format.

Are TrackingNumbers numeric, or do they contain alphabetics?
Can you post a jpg of your tables and relationships to help readers understand your tables/requirements?
You could do this on one form, but you mentioned 3 forms--any particular requirement?

[mwc0914]

Tracking number is numeric only. I want 3 forms because although I only listed 2 queries, there will ultimately be about 6 different queries on the same data, and it would be too cumbersome for all the queries on one form, so I would rather have 1 query per form, then a common output form for all quereies. All data is from single table.
I will ultimately add more fields and more queries.

[orange]

Since you are working with only 1 table, and you have about 5 -6 queries and only 1 output,

you could consider an Option Group to identify which query to run, and put the results into a single output
form of listbox or??? Something like attached jpg

[mwc0914]

Some of the future queries will have multiple search terms, so I thought it better to handle each search separately on its own form.