Multiple control sources

[Prohock]

I have a report that has a table for a control source. The majority of the
data for my report is located in this table. For my report, I also need some
data located that is located in a query that I have made. I am hoping that I
do not have to change my record source to this query, as I have so much data
in the table and the report has has been developed using my table as a
control source. Is it possible to imbed a record within a record that would
have a different control source than my main record, ie (query rather than
table). Also I can't understand why Access would list the query in the
expression builder, and then when I write an expression that requires this
field, I get the "enter parameter value" error???? Please help and explain...

 

[Duane Hookom]

A report can have only one "record source" (control sources are for controls
on your report). If your table and query are related by field values
contained in the table and query, you should be able to set your record
source to a query or SQL statement that contains both the table and query.