Link Child Field Join Properties

[amandadrtv]

How do I pull values from the subreport where the main report does not contain the field on which the subreport is linked?

The subreport is linked to the main report by Date, and it contains a date (10/01/2005) that the main report does not. However, I would like to pull 10/01/2005 in the report. I guess I'm looking to change the join properties.

Is this possible?

 

[dhookom]

Why not remove the values from the Link Master/Child properties of the subreport control?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[amandadrtv]

Sorry, dhookom, I don't think I understand your suggestion. I need the report to pull all the dates that the subreport contains, even when the main report does not contain them.

Thanks,
Amanda

 

[dhookom]

A subreport container control has Link Master and Link Child properties. What is in these properties? Have you tried setting these to blanks?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]