Database Report field

[timcos@gmail.com]

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.

[jimfortune@compumarc.com]

Re: Database Report field

tim...@gmail.co m wrote:[color=blue]
> 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[/color]
of[color=blue]
> course in the actual text box.
>
> When I preview my report...this field and all fields return the[/color]
result[color=blue]
> "#Name?" again no quotes on report preview.
>
> What is this...I obviously have something wrong.
>
> Thansk in advance.[/color]

If I understand you correctly, you are trying to use an Access Report
to do something like a mail merge in Word. If "Client Info List" is
actually the name of the table in the database then you can assign it
to the report's Record Source. Then you can put =[LLC NAME] in for the
Control Source of the text box. If you want to limit the number of
records returned you can use a query based on that table as the
report's Record Source.

You're welskome,

James A. Fortune

[fredg]

Re: Database Report field

On 14 Feb 2005 07:55:34 -0800, timcos@gmail.co m wrote:
[color=blue]
> 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.[/color]


The name of the Database is "ClientnfoL ist" 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] = " &
[AControlValueon Report)
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.

[Sean]

Re: Database Report field

Make sure the Name of the Text Box is not the same as the Name of the
Control for the Text Box.