Can a form be based on two queries?

's Computer Specifications

I have a fairly complicated query that I based a form
on. Basically this query only gives me one text box
on my form.

I want two more text boxes on my form based on two more different and not
related queries.

My form is currently based on a record that sums up the amount of one field
in a complex query. This box
behaves as I wish it to do.

's Computer Specifications

No, it can't. But you can include subforms based on another query/table.

"tom" wrote:

> I have a fairly complicated query that I based a form
> on. Basically this query only gives me one text box
> on my form.
>
> I want two more text boxes on my form based on two more different and not
> related queries.
>
> My form is currently based on a record that sums up the amount of one field
> in a complex query. This box
> behaves as I wish it to do.
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Form based on query that is based on many queries	DMainland	Microsoft Access VBA Modules	1	9th May 2008 10:51 PM
Create queries based on form selections	dreamsoul620	Microsoft Access Queries	2	21st Feb 2006 02:09 PM
Form based on two queries	Robin Chapple	Microsoft Access Forms	11	27th Jun 2005 11:49 PM
saved queries based on other saved queries vs. one big query in a form's module using DAO	Richard Hollenbeck	Microsoft Access Queries	5	23rd Sep 2004 08:38 PM
Queries based on user input on form	Robert Cs.	Microsoft Access Forms	1	19th Feb 2004 08:34 PM