text box datasource refer to a field in a table

[klin]

Hi,
I am building a report that gives a summary on all purchase order in a period
of time.
For the report, I have the query set up no problem, but on the report Head, I
would like to make it dynamic so that it can display a company name field
from another table (not included in the report's datasource).
Using the expression builder I got the following:

=[company name]!CompanyName

[company name] is the name of the table and CompanyName is the name of the
field in the table.
When I try to run the report, it promps me for a variable, somehow it doesn't
recognize that [company name] is a table and thinks that it's a name of a
variable.

Thanks in advance.

klin

 

[Ken Snell \(MVP\)]

Use the DLookup function:

=DLookup("CompanyName", "company name")

 

[klin]

wow! awesome! thanks! this problem's been bugging me for a few days already.

Thanks alot!

Use the DLookup function:

=DLookup("CompanyName", "company name")

Hi,
I am building a report that gives a summary on all purchase order in a

[quoted text clipped - 18 lines]

klin