On 14 Feb 2005 07:55:34 -0800,
ti****@gmail.com wrote:
OK...I am creatiung a report...much like a letter.
I have a text box. It is supposed to hold the LLC Name'
The database is "Client Info List"
The field is called "LLC NAME"
The text box has in it..."=[Client Info List]![LLC NAME]" no quotes of
course in the actual text box.
When I preview my report...this field and all fields return the result
"#Name?" again no quotes on report preview.
What is this...I obviously have something wrong.
Thansk in advance.
The name of the Database is "ClientnfoList" or the name of the table
in the database is "ClientInfoList"? Which?
I suspect you mean the name to the table used.
Is the [LLC Name] field included in the Report record source?
If so just use a text control BOUND to [LLC Name] (no = sign or table
name, just [LLC Name] as the control source).
If it is NOT part of the report's record source, then you need to use
a DLookUp().
=DLookUp("[LLC Name]","[ClientInfoList]","[SomeIDField] = " &
[AControlValueonReport)
The Criteria portion of this expression determines if you get the
correct value.
Make sure the name of this control is not the same as the name of any
field in it's control source expression.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.