Coding not Working in Report

[specialk]

HELP. need someone to look at coding below, and see if they can tell me why
it is not working.

I have a letter in report format.

In the report i need the our clientcompany to be pulled in.

The lady that designed our database used a code to do it, but it's pulling
all the wording in but the client company.

="My Company Name, was hired by " & [clientCompany] & " to conduct an
investigation on the above referenced address."

When you go and click on the field, it shows this hole wording is in the
control source box. Like i said it is showing all the wording but the
clientcompany.

 

[Ken Sheridan]

What is the RecordSource of the report? ClientCompany is presumably a field
in the underlying RecordSource, which is likely to be a query. The fact that
its not showing in the text box suggests that ClientCompany is Null.

If the RecordSource is a saved query rather than an SQL statement open the
query independently of the report and see what it shows in the ClientCompany
column. Then you need to determine what's needed to ensure it contains the
correct value, but that depends on just how the report and query are designed
to operate, so we'd need more information before we could give a categorical
answer.

Ken Sheridan
Stafford, England