By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,695 Members | 1,597 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,695 IT Pros & Developers. It's quick & easy.

Database Report field

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
tim...@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.


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

Nov 13 '05 #2

P: n/a
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.
Nov 13 '05 #3

P: n/a
Make sure the Name of the Text Box is not the same as the Name of the
Control for the Text Box.
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.