Can't build a link between unbound forms???

[sjh]

Hi,
I created a sub-report. In the subreport properties window, when I try to specify the "Link Child Fields" and "Link Master Fields", I get this error message.

Can't build a link between unbound forms

How can I link these two reports together?

Thank you for your help!!!

SJH

 

[jiqjaq]

If you're going to use the link fields properties, you need to have reports that have fields bound to the data. The ControlSource property must be set to the name of the field or SQL statement which provides this data. Similarly, the RecordSource needs to be set either in the property window or in code to bind the report.

 

[dhookom]

Or, just don't click the builder button [...]. Just enter the field name(s) into the properties.

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]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[GingerR]

or in the subreport, put criteria in the query it's built on, referencing a control on the main report:

[Reports]![MainReport]![txtID]

or something like that.

then AfterUpdate on the control that's on the main form, requery the subreport.

g