Display ID & Designator

[MackBlale]

I have a table that stores a Handling Team ID based upon a Cascading Combo
Box based upon a qry:

SELECT tblHandlingTeam.HandlingTeam, tblHandlingTeam.IDTeam,
tblHandlingTeam.IDHandlingCtr, tblHandlingTeam.TmDesig
FROM tblHandlingTeam
WHERE (((tblHandlingTeam.IDHandlingCtr)=[Forms]![LNA
Record]![HandlingCenter]))
ORDER BY tblHandlingTeam.IDTeam;

Each team has a Designator = TmDesig. I am tryin to cocantenate the
ClientID stored in tblEmployees with the TmDesig from tblHandlingTeam.

First I wrote qryDesigNtr

SELECT tblHandlingTeam.HandlingTeam, tblHandlingTeam.TmDesig
FROM tblHandlingTeam
ORDER BY tblHandlingTeam.TmDesig;

and then tried to display the Client ID and Team Designator in an unbound
textbox with this:

=[ClientID] & [qryDesigNtr]![TmDesig]

I keep getting this errror:

#Name?

Can someone point me in the right direction

Mack

 

[Tom Wickerath]

Hi Mack,

Where are you getting the [ClientID] value from? Can you base this form on a
query that includes the [ClientID] and the [TmDesig] fields? If yes, then you
should be able to concatenate like this:

=[ClientID] & [TmDesig]

This expression will not work, as you have already determined:

=[ClientID] & [qryDesigNtr]![TmDesig]

You need to use fields that are in the form's recordsource, or you need to
use a domain aggregrate function, if it is not possible to include both
fields in the form's recordsource. Here is more information on using one
domain aggregrate function, DLookup (all of them use the same types of
parameters):

DLookup Usage Samples
http://www.mvps.org/access/general/gen0018.htm

Make sure that the name of the text box is *not* the same as one of the
fields involved in the concatenation (ie. ClientID or TmDesig). If you use
the lowercase "txt" naming convention for a text box, this will help prevent
circular reference errors that would otherwise result.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

I have a table that stores a Handling Team ID based upon a Cascading Combo
Box based upon a qry:

SELECT tblHandlingTeam.HandlingTeam, tblHandlingTeam.IDTeam,
tblHandlingTeam.IDHandlingCtr, tblHandlingTeam.TmDesig
FROM tblHandlingTeam
WHERE (((tblHandlingTeam.IDHandlingCtr)=[Forms]![LNA
Record]![HandlingCenter]))
ORDER BY tblHandlingTeam.IDTeam;

Each team has a Designator = TmDesig. I am tryin to cocantenate the
ClientID stored in tblEmployees with the TmDesig from tblHandlingTeam.

First I wrote qryDesigNtr

SELECT tblHandlingTeam.HandlingTeam, tblHandlingTeam.TmDesig
FROM tblHandlingTeam
ORDER BY tblHandlingTeam.TmDesig;

and then tried to display the Client ID and Team Designator in an unbound
textbox with this:

=[ClientID] & [qryDesigNtr]![TmDesig]

I keep getting this errror:

#Name?

Can someone point me in the right direction

Mack