Multiple queries to populate form

  • Thread starter Thread starter sifford
  • Start date Start date
S

sifford

I would like to know if it is possible to use multiple
fields from multiple queries to populate a form without
linking the different queries together.

For example, I have two queries labeled Query1 and
Query2. In Query1, there are two fields labeled Field1
and Field2. In Query2, there are two fields labeled
Field3 and Field4.

Is there some way to create a form that allows me to
place Field1, Field2, Field3, and Field4 in the form
without linking Query1 and Query2 together in the main
query used for the record source?
 
Thank you for posting a response. Actually, I'm not
trying to create a nested query (if I understand your
response correctly). Using my original example, I just
want to take the values from Fields 1,2,3,4 from the two
example queries and have them display on the form. These
values don't have any relation to one another. Any
suggestions how to handle this?
 
I would like to know if it is possible to use multiple
fields from multiple queries to populate a form without
linking the different queries together.

For example, I have two queries labeled Query1 and
Query2. In Query1, there are two fields labeled Field1
and Field2. In Query2, there are two fields labeled
Field3 and Field4.
Click to expand...

How many RECORDS in Query1? How many in Query2? Does it matter which
record from Query1 is displayed along with a particular record from
Query2?
Is there some way to create a form that allows me to
place Field1, Field2, Field3, and Field4 in the form
without linking Query1 and Query2 together in the main
query used for the record source?
Click to expand...

You can use a Form based on Query1, with a Subform based on Query2.
But which record you see on which (part of the) form will be
arbitrary.
 
yes, my answer still stands, use sub forms.

Make a sub-form for each of the quires data that you want to display. Each
of those sub-forms can then display the data for its own query. They do not
have to have any relation to each other in any way.

You can also use a listbox, as they are quite good in this regards also. If
you use sub-forms, then the data is editable. if you don't need the data to
be editable, then I would probably use a listbox for each query. (build the
query, and then use the wizard to make the listbox for each query on the
screen). In fact, a listbox is probably a better choice here then is a
sub-form, but both will equally work well.
 
Back
Top