Cannot pull field from related table into report

[Guest]

Access 2003

Have setup a relationship on " Def number" between tables.
Even added that relationship to the query which feeds the report in question.

In the control source on the Report I entered:
=[Category] & Chr(13) & Chr(10) & "(" & [Type] & ")" & Chr(10) & Chr(10) &
[tblChart3]![Status]

It fails by requesting a value for tblChart3.

Also the Report's control source changes to:
=[Category] & Chr(13) & Chr(10) & "(" & [Type] & ")" & Chr(10) & Chr(10) &
tblChart3!Status

[Category] and [Type] are from the Primary table whereas
[tblChart3] is in the related table.

Need help! Thanks

 

[SusanV]

Hi Dennis,

Replace the ! with a period:

=[Category] & Chr(13) & Chr(10) & "(" & [Type] & ")" & Chr(10) & Chr(10) &
[tblChart3].[Status]

 

[Guest]

Dennis,

Include the field in a query upon which the report is based to access it.

Sprinks