"Marshall Barton" wrote
Blackhole said:
Never Mind. I see. I need to rename it in the source table
"Marshall Barton" wrote
(e-mail address removed) wrote:
Trying to create a concatenated text box value on a report. The
control source is
="Applications:" & [Application]
[Application] is a drop down list box. The source of the report is
directly from a table.
I always get a #error# for the result. This works fine on a regular
text field from the table (non drop down list box), so I know there is
something stupid I am missing.........
Change the name of the text box to someting other than
Application (the usual naming convention would be
txtApplication).
The concatenated text box is actually called "text14" Or are you
referring
to the table field [applications]?
Example of what I want the field to say:
"Applications: WinDVD" where the WINDVD would be what is pulled from the
drop down field [application] and "applications:" is the plain text
concatenated to the front of it.
Sorry, the most common reason for that error is that the
text box and the field have the same name. You should not
need to change the name of a field in a table.
Okay. I thought I checked for that, but I have missed simpler things. I wil
look again. The fact that it worked when I changed the name in the source
table should be an indicator I probably overlooked soemthing.
If Application is the name of a field in the table, then
double check that you do not have a control anywhere in the
report with that name.
If I have misunderstood again, please try to clarify what is
where. The use of a lookup field in your table may (or may
not) be a big part of the confusion because what you see is
not necessarily what you get with those things.
Agreed. This was a quick and dirty database to track my computer inventory
and I did not have enoug time to do proper lookups using forms or queries.
It was easier to build it into the table at the time.