How do I add a second query to an existing form?

[lolpros]

I've built a form based on a huge query and am not getting back all the
records. I think I know which tables are causing the problem, so I would
like to parse those out to individual queries (which work) and put them back
in the one form. Is this possible? Big thank you to anyone that can help!!

 

[John W. Vinson]

I've built a form based on a huge query and am not getting back all the
records. I think I know which tables are causing the problem, so I would
like to parse those out to individual queries (which work) and put them back
in the one form. Is this possible? Big thank you to anyone that can help!!

More than a little bit difficult for anyone to answer! We know nothing about
your tables, your queries, how the tables and queries are related...

Typically you will use a Form with one or more Subforms rather than trying to
create one massive master query that does everything; such a large multitable
query will almost surely not be updateable.

You may also want to change the Joins in some of your queries to "Outer Joins"
- click the join line in query design view and choose the option "Show all
records in THISTABLE and matching records in THATTABLE".

If you'll post some more details about your structure it may be possible for
someone to give a more specific answer.