Subreport Not Displaying

[Guest]

My main report is a 1 record query. It has a customer rep's name, and the
date the records are from in it. I created a query that showed all the cases
and issues related to them, created a report off that query. No restriction
in that query regarding who or when. That report shows up fine by itself.

I try to use that new report as a subreport in the single record report, and
nothing shows. Admittedly, I try to stay away from subreports (really I just
don;t get too many opportunities where they seem appropriate), so maybe I'm
missing something real simple. I *think* I have linked things propery-the
Master recordset has fields "Name" and "Audit_Date"...so does the
sub-report...and they are formatted the same.

Is it possible that the problem lies in the sorting/grouping in the sub? I
have a sorting group in the subreport based on an expression.

I hope I've explained this in enough detail...if not question away and I'll
try to give more detail. Thanks in advance...

 

[Duane Hookom]

One possible issue is having a field named name. Having a name of name can
be very confusing to a report or form. For instance, the following control
source in a report text box:
=[Name]
may display the report's name, not the value from a field named name.

I would rename the name field in the report's record source to another name
that is not name. That way if you need to set the Link Master Child
properties to a field name, it is not name.

 

[Guest]

Good call, Duane! Changed the field names to "CRName" on both sides and
things worked as expected. You'd figure after 8 years of using Access I'd
have been able to figure that one out!

Appreciate the hint! Thanks a lot!