Two separate Query results on form

  • Thread starter Thread starter Tom via AccessMonster.com
  • Start date Start date
T

Tom via AccessMonster.com

I would like to make a form on which I can display the results of two queries
showing several records in datasheet view. The form would be used as a status
screen for records in the database. Is there anyway of doing this?

Thanks,

Tom
 
Tom via AccessMonster.com said:
I would like to make a form on which I can display the results of two
queries
showing several records in datasheet view. The form would be used as a
status
screen for records in the database. Is there anyway of doing this?
Click to expand...


You can create an unbound form and place two subforms on it. Each subform
would have one of your queries as its recordsource.
 
Thanks for replying,
How do I link them? I need them both on the same page and the records in one
are not data related to the other.

Tom


KARL said:
Link the status query in the other so you wil have only one record source.
I would like to make a form on which I can display the results of two queries
showing several records in datasheet view. The form would be used as a status
Click to expand...
[quoted text clipped - 3 lines]
Tom
Click to expand...
Click to expand...
 
You said "status screen for records in the database" so the information must
be related is it not?

Tom via AccessMonster.com said:
Thanks for replying,
How do I link them? I need them both on the same page and the records in one
are not data related to the other.

Tom


KARL said:
Link the status query in the other so you wil have only one record source.
I would like to make a form on which I can display the results of two queries
showing several records in datasheet view. The form would be used as a status
Click to expand...
[quoted text clipped - 3 lines]
Tom
Click to expand...
Click to expand...
Click to expand...
 
Thank You! That worked great.

Tom

Joan said:
You can create an unbound form and place two subforms on it. Each subform
would have one of your queries as its recordsource.
Click to expand...
 
Without knowing your database / queries, I am guessing that you need to use
the Union Query to combine 2 Queries into one.

Check Access Help on Union Queries.
 
Back
Top