I'm having trouble linking a subreport.  I've done this many times in the
past with forms and reports and I've narrowed the problem down to the
crosstab query.  I created a crosstab query and then joined it to other
tables in another query.  I'm using this query in the subreport.  When I take
the crosstab out of the query I can  select fields to link the reports, when
I add the crosstab back into the query I get the error:  Refers to an object
that is closed or doesen't exist.  Need help on why this error is happening
and how to correct this problem.

The tables I'm using each have SSN set as primary key- each year new grants
are appended into a grant table so I need present each year with the grant
amounts in this format:  
SSN                   2005             2006            2007
999-99-9999       100                110               50