[mso] Re: (ACCESS) LOOKUP

Thanks for responding, April.

I've changed that, but for what's its worth, its driving me nuts cause it is 
not working. Would you be willing to look at a very small, simple demo access 
file just showing this example? Maybe I can post it somewhere, and you can look 
at it. It never returns the field I want. I want it to show three columns... 
but, return the value of the second column. But, it just will not work. No 
errors or anything, but rather just returns the wrong info.

---Charlie

  ----- Original Message ----- 
  From: April R. Pace 
  To: mso@xxxxxxxxxxxxx 
  Sent: Wednesday, May 15, 2002 9:01 PM
  Subject: [mso] Re: LOOKUP



  First I will assume that you are in Access... While in Design view ... if
  you have already created the lookup look down at the properties and click on
  the lookup tab.  there is a field labeled "bound Column" does it say "3"?
  Change it to "2"... when you created the lookup, there should have been a
  screen that asked you which field you want to save... you must a missed this
  screen.

  April

  -----Original Message-----
  From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
  Behalf Of Charles Ippolito
  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.

  http://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.

  http://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.

http://www.freelists.org/webpage/mso
*************************************************************

Other related posts: