[mso] Re: (Access) LOOKUP
- From: "Charles Ippolito" <CharlesMTFAccess@xxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Fri, 10 May 2002 08:47:52 -0400
But, it's not. That's EXACTLY what I'm doing. The value it returns is NOT the
second column. Maybe I'm just going nuts, who knows. I'm willing to show you on
a sample EXTRA SMALL database that I can post somewhere if interested. I have 3
columns in the lookup. I want column #2 to be returned, but it never works.
---Charlie
----- Original Message -----
From: James LaBorde
To: 'mso@xxxxxxxxxxxxx'
Sent: Thursday, May 09, 2002 5:30 PM
Subject: [mso] Re: (Access) LOOKUP
Charlie,
On your lookup tab, find the row that says Bound Column and change it from 1
to 2. This will make Access store the second column's value as the value in
your field. (The trick is to make sure this uniquely identifies the row!)
James
-----Original Message-----
From: Charles Ippolito [mailto:CharlesMTFAccess@xxxxxxxxxxx]
Sent: Thursday, May 09, 2002 2:08 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: (Access) LOOKUP :VSMail MX2
Well, it IS the BOUND COLUMN, but no matter what I put in there it never
returns the correct value that I want entered into the field.
---Charlie
----- Original Message -----
From: Glenda Wells
To: 'mso@xxxxxxxxxxxxx'
Sent: Thursday, May 09, 2002 3:38 PM
Subject: [mso] Re: LOOKUP
maybe change the bound column is the lookup properties??
-----Original Message-----
From: Charles Ippolito [mailto:CharlesMTFAccess@xxxxxxxxxxx]
Sent: Thursday, May 09, 2002 2:58 PM
To: MSO
Subject: [mso] LOOKUP
One of my tables contains a field, we'll call it field A. When entering
data
on field A, I want to do a LOOKUP to ensure that the only data that can be
entered is what is in another table. So I use the LOOKUP wizard, and
create
a LOOKUP using 3 fields from another table. When entering the data, it
shows
the 3 columns from the lookup table, but when I select one of the choices,
it returns the value of the first field. I want it to return the value of
the second field. I know I can just change the order, but I want it
alphabetized by the first column, but the second column to be the return
field.
Any help is greatly appreciated!
---Charles
*************************************************************
PLEASE READ!!!!
You are receiving this mail because you either subscribed to
mso@xxxxxxxxxxxxx or to it's earlier version,
MicrosoftOffice@xxxxxxxxxxxxxxxx
To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx
with a subject line that says "unsubscribe" (without the quotes). Do not
put unsubscribe IN CAPS. Screaming doesn't get you out any faster and the
caps prevent the function from working.
To change your email settings to digest or vacation (no mail), visit the
group's homepage for full instructions.
//www.freelists.org/webpage/mso
*************************************************************
*************************************************************
PLEASE READ!!!!
You are receiving this mail because you either subscribed to
mso@xxxxxxxxxxxxx or to it's earlier version,
MicrosoftOffice@xxxxxxxxxxxxxxxx
To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx
with a subject line that says "unsubscribe" (without the quotes). Do not
put unsubscribe IN CAPS. Screaming doesn't get you out any faster and the
caps prevent the function from working.
To change your email settings to digest or vacation (no mail), visit the
group's homepage for full instructions.
//www.freelists.org/webpage/mso
*************************************************************
*************************************************************
PLEASE READ!!!!
You are receiving this mail because you either subscribed to
mso@xxxxxxxxxxxxx or to it's earlier version,
MicrosoftOffice@xxxxxxxxxxxxxxxx
To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx
with a subject line that says "unsubscribe" (without the quotes). Do not
put unsubscribe IN CAPS. Screaming doesn't get you out any faster and the
caps prevent the function from working.
To change your email settings to digest or vacation (no mail), visit the
group's homepage for full instructions.
//www.freelists.org/webpage/mso
*************************************************************
*************************************************************
PLEASE READ!!!!
You are receiving this mail because you either subscribed to
mso@xxxxxxxxxxxxx or to it's earlier version, MicrosoftOffice@xxxxxxxxxxxxxxxx
To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx
with a subject line that says "unsubscribe" (without the quotes). Do not put
unsubscribe IN CAPS. Screaming doesn't get you out any faster and the caps
prevent the function from working.
To change your email settings to digest or vacation (no mail), visit the
group's homepage for full instructions.
//www.freelists.org/webpage/mso
*************************************************************
*************************************************************
PLEASE READ!!!!
You are receiving this mail because you either subscribed to mso@xxxxxxxxxxxxx
or to it's earlier version, MicrosoftOffice@xxxxxxxxxxxxxxxx
To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with
a subject line that says "unsubscribe" (without the quotes). Do not put
unsubscribe IN CAPS. Screaming doesn't get you out any faster and the caps
prevent the function from working.
To change your email settings to digest or vacation (no mail), visit the
group's homepage for full instructions.
//www.freelists.org/webpage/mso
*************************************************************
Other related posts:
