Using Access XP...
Admin. in the Mrktng dept. is going to track data using marketing codes
where the first 3 characters will be the marketing code and the last two the
current year. For example: ABC06, ABC07, ABC08, etc. however, when the staff
is going to enter the data in a form a drop down MUST show only ACD.

I created a table for the marketing codes information and linked to a field,
etc., etc. I have no problem with any of that. The problem is that when the
staff clicks on the drop down arrow they can see ABC08 instead of only ABC.

I indicated that it does not matter that staff can see ABC08 instead of only
ABCbut Admin. is adamant about it and it has to be only ABC.

I hope this make sense (as a problem to be solved, not the logic behind my
boss).

Thanks for any help.

If your source for the drop down pulls from the table you created, change the
source of the drop down to select Left([mktCode],3)

Ricoy-Chicago wrote:
>Using Access XP...
>Admin. in the Mrktng dept. is going to track data using marketing codes
>where the first 3 characters will be the marketing code and the last two the
>current year. For example: ABC06, ABC07, ABC08, etc. however, when the staff
>is going to enter the data in a form a drop down MUST show only ACD.
>
>I created a table for the marketing codes information and linked to a field,
>etc., etc. I have no problem with any of that. The problem is that when the
>staff clicks on the drop down arrow they can see ABC08 instead of only ABC.
>
>I indicated that it does not matter that staff can see ABC08 instead of only
>ABCbut Admin. is adamant about it and it has to be only ABC.
>
>I hope this make sense (as a problem to be solved, not the logic behind my
>boss).
>
>Thanks for any help.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200801/1

On Tue, 8 Jan 2008 12:52:01 -0800, Ricoy-Chicago wrote:

> Using Access XP...
> Admin. in the Mrktng dept. is going to track data using marketing codes
> where the first 3 characters will be the marketing code and the last two the
> current year. For example: ABC06, ABC07, ABC08, etc. however, when the staff
> is going to enter the data in a form a drop down MUST show only ACD.
>
> I created a table for the marketing codes information and linked to a field,
> etc., etc. I have no problem with any of that. The problem is that when the
> staff clicks on the drop down arrow they can see ABC08 instead of only ABC.
>
> I indicated that it does not matter that staff can see ABC08 instead of only
> ABCbut Admin. is adamant about it and it has to be only ABC.
>
> I hope this make sense (as a problem to be solved, not the logic behind my
> boss).
>
> Thanks for any help.

In whatever query you are using as the Combo rowsource, add a new
column:

CodeInfo:Left([FieldName],3)

Then set this column to be the one displayed, not the current column.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Thank you both... that's what I was looking for :-)

"fredg" wrote:

> On Tue, 8 Jan 2008 12:52:01 -0800, Ricoy-Chicago wrote:
>
> > Using Access XP...
> > Admin. in the Mrktng dept. is going to track data using marketing codes
> > where the first 3 characters will be the marketing code and the last two the
> > current year. For example: ABC06, ABC07, ABC08, etc. however, when the staff
> > is going to enter the data in a form a drop down MUST show only ACD.
> >
> > I created a table for the marketing codes information and linked to a field,
> > etc., etc. I have no problem with any of that. The problem is that when the
> > staff clicks on the drop down arrow they can see ABC08 instead of only ABC.
> >
> > I indicated that it does not matter that staff can see ABC08 instead of only
> > ABCbut Admin. is adamant about it and it has to be only ABC.
> >
> > I hope this make sense (as a problem to be solved, not the logic behind my
> > boss).
> >
> > Thanks for any help.
>
> In whatever query you are using as the Combo rowsource, add a new
> column:
>
> CodeInfo:Left([FieldName],3)
>
> Then set this column to be the one displayed, not the current column.
>
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail
>

Hi Ricoy, the control source for a text box be something like this
=UCase(Left(Nz(DLookUp("[OwnerLastName]","tblOwnerInfo","[OwnerID] = " &
[tbOwnerID] & ""),""),3))
Regards Bob hope you can use this

"Ricoy-Chicago" <(E-Mail Removed)> wrote in message
news:541113E9-46FF-4F7D-B33F-(E-Mail Removed)...
> Using Access XP...
> Admin. in the Mrktng dept. is going to track data using marketing codes
> where the first 3 characters will be the marketing code and the last two
> the
> current year. For example: ABC06, ABC07, ABC08, etc. however, when the
> staff
> is going to enter the data in a form a drop down MUST show only ACD.
>
> I created a table for the marketing codes information and linked to a
> field,
> etc., etc. I have no problem with any of that. The problem is that when
> the
> staff clicks on the drop down arrow they can see ABC08 instead of only
> ABC.
>
> I indicated that it does not matter that staff can see ABC08 instead of
> only
> ABCbut Admin. is adamant about it and it has to be only ABC.
>
> I hope this make sense (as a problem to be solved, not the logic behind my
> boss).
>
> Thanks for any help.
>