Getting forms to work from multiple queries

[Guest]

I am fairly new so I still don't understand some things. I would like to
create a form from numerous queries. I don't want to build one large query
with all my data I need for the form because it would be too large. When I
try to add queries in form wizard, I get the message "You have chosen fields
from record sources which the wizard can't connect." Is there a way to have a
form from multiple (5 or 6) queries that are syncronized where all of the
data scrolls at once? In other words, I need a form based on 5 or 6 queries
that all works together, if I pick "school" all the others fields change,
etc. Thanks in advance for any help.

 

[Guest]

You can use those 5-6 queries in a single query. Just join them, left join
for one-to-many. Then use that query in your form. Alternate is to use
form/subform with Master/Child links on the common field of the one-to-many.