I have two working queries that I would like to use to create one form. I
get an error message that I have chosen fields from record sources which the
wizard can't connect. You may have chosen fields from a table and from a
query based on that table. If so, try choosing fields from only the table or
only the query. If I chose just one of the queries I don't get that message.
Am I not allowed to combine queries in a form? I also tried in report and
got the same results. I added a relationship between the two queries and
stil ge the same message.

What about using a subform and use the common field as the Master/Child link
between the form and subform.
--
KARL DEWEY
Build a little - Test a little


"skigal" wrote:

> I have two working queries that I would like to use to create one form. I
> get an error message that I have chosen fields from record sources which the
> wizard can't connect. You may have chosen fields from a table and from a
> query based on that table. If so, try choosing fields from only the table or
> only the query. If I chose just one of the queries I don't get that message.
> Am I not allowed to combine queries in a form? I also tried in report and
> got the same results. I added a relationship between the two queries and
> stil ge the same message.

This works but doesn't make for very pretty presentation. I have done this
to get us through this project but am wondering if there happens to be any
other alternative solutions that would allow for a more uniform looking
presentation of the data from the two tables.

"KARL DEWEY" wrote:

> What about using a subform and use the common field as the Master/Child link
> between the form and subform.
> --
> KARL DEWEY
> Build a little - Test a little
>
>
> "skigal" wrote:
>
> > I have two working queries that I would like to use to create one form. I
> > get an error message that I have chosen fields from record sources which the
> > wizard can't connect. You may have chosen fields from a table and from a
> > query based on that table. If so, try choosing fields from only the table or
> > only the query. If I chose just one of the queries I don't get that message.
> > Am I not allowed to combine queries in a form? I also tried in report and
> > got the same results. I added a relationship between the two queries and
> > stil ge the same message.

What about using a report and subreport?
--
KARL DEWEY
Build a little - Test a little


"skigal" wrote:

> This works but doesn't make for very pretty presentation. I have done this
> to get us through this project but am wondering if there happens to be any
> other alternative solutions that would allow for a more uniform looking
> presentation of the data from the two tables.
>
> "KARL DEWEY" wrote:
>
> > What about using a subform and use the common field as the Master/Child link
> > between the form and subform.
> > --
> > KARL DEWEY
> > Build a little - Test a little
> >
> >
> > "skigal" wrote:
> >
> > > I have two working queries that I would like to use to create one form. I
> > > get an error message that I have chosen fields from record sources which the
> > > wizard can't connect. You may have chosen fields from a table and from a
> > > query based on that table. If so, try choosing fields from only the table or
> > > only the query. If I chose just one of the queries I don't get that message.
> > > Am I not allowed to combine queries in a form? I also tried in report and
> > > got the same results. I added a relationship between the two queries and
> > > stil ge the same message.