2nd query in report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report based on a crosstab query. The report header takes values from a form used to select parameters for the query. This all works fine. I now would like to add a combo box in the detail section of the report with a row source different from the recordsource of the report. The rowsource query does reference a field in the detail section as criteria for the query. I tested the query separately and it works fine, so i'm wondering if it's even possible to do this.

Many thanks to this ever helpful site!

Bob
 
Bob said:
I have a report based on a crosstab query. The report header takes values from a form used to select parameters for the query. This all works fine. I now would like to add a combo box in the detail section of the report with a row source different from the recordsource of the report. The rowsource query does reference a field in the detail section as criteria for the query. I tested the query separately and it works fine, so i'm wondering if it's even possible to do this.


Not sure I understand. If you're trying to use a combo box
to look up a value in another table, that's definitly the
long way around. Try using a text box with a DLookup
function instead.
 
Try it. If you have trouble, come back with some properties, fields, etc.

--
Duane Hookom
MS Access MVP


Bob Ewers said:
I have a report based on a crosstab query. The report header takes values
from a form used to select parameters for the query. This all works fine.
I now would like to add a combo box in the detail section of the report with
a row source different from the recordsource of the report. The rowsource
query does reference a field in the detail section as criteria for the
query. I tested the query separately and it works fine, so i'm wondering if
it's even possible to do this.
 
Back
Top