Queries not avaliable to be added to form? All Table fields are.

[sup909]

Access 2007

I am trying to create a basic form that will display some information from a
table and from the results of some queries.

I am able to add fields from my tables to the form without any problems, but
I am unable to add any of the fields from my queries to the form. In Design
Mode under "Add Existing Fields" my queries are not even avaliable as an
optionto choose from.

After trying to add them in by hand by going to the control source and then
the expression builder the only result I get in the resulting box is the
dredded "#NAME?" error.

I am starting off with a blank form. Anyone know how to add the fields from
tables and queries? It seems like it should be simple.

BTW I also have all of my tables and queiries linked using an ID number in
the relationship tool.

 

[Klatuu]

You cannot do what you are trying to do. A form can have only one record
source. You may need to use a subform for each query you want to get data
from.