Stupid Newbie Report Problem

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

Guest

My main table has combo box links to other "sub-tables" in order to limit
input choices yet allow flexibility by changing only the linked sub-table.
If I run a Query or a plain Report on the main table, all the linked data
appears. But if I create a Report that is Grouped on one of the linked
fields, I get the Linked table record ID instead of the data. I have similar
problems in Query mode, but that's for another section!

I feel certain I'm making a stupid newbie mistake. I've used Access for
several years but not in this fashion.

Any ideas?

Doug
 
Include the "sub-tables" in the report's record source query. You can then
place the required values into the report.
 
I'm not sure if I understand correctly, but you have a various fields in your
table that are look-up type fields, and the link to that look-up field
depends on the value of another field.

if Field1 = 1 then lookup source table (of field2) is Table1
if Field1 = 2 then lookup source table of Field2 is Table2

If this is correct, then you can do VBA in the detail section of your
report, and change the look-up fields, rowsource property based on the value
of Field1.
 
Thanks, Duane, that solved the problem. Seems to me I was right: it was a
stupid question. I know that the query wizard doesn't always yield the best
results, and this is one example.

Doug
 
Thanks for the info--this taught me more about modifying rowsource properties
when initial results don't match expectations.

The previous reply also worked, so my final choice may be based on which
method is "easier" to document.

Doug
 
I don't mind when my solution is not the right one - just as long as it was
helpful and/or education :-> Have a happy new year
 
Back
Top