View original (French)

ACCESS = retrieve value from column 2?

Solved
HELD_tokyo Posted messages 64 Status Member -  
HELD_tokyo Posted messages 64 Status Member -
Hello everyone,

I have a request form.

It includes a combobox called Ctntype. When I click on it, I have the option to choose from several options.
The data is displayed in two columns. This means that the lookup performed on this combobox allows viewing two columns from the source table.

My combobox returns a value. That of the first column.

I would like to create a second cell that automatically displays the result of the second column of the combobox. How can I do that?

I created an input field and typed the code =[Ctntype]
It returns the value of the combobox, but column 1. How can I get it to be column 2?

Basically, when I click on my combobox, I get this:

CARROT VEGETABLE
HORSE MEAT

I want the combobox to retain its value of carrot or meat
I want a second field to return the value Vegetable or Meat depending on my selection.

Thank you all, I don't think it's complicated...

Held
Configuration: Windows XP Internet Explorer 6.0

3 answers

  1.
    blux Posted messages 2045 Registration date   Status Moderator Last intervention   3 455
     
    Hi,

    have you tried Ctntype.column(n) with n being the number of the column you want (starting at zero, I believe)?

    --

    A+ Blux 
     "Fools dare everything. It's even how we recognize them."
    2
  2. HELD_tokyo Posted messages 64 Status Member 1
     
    Beautiful...
    Works wonderfully with the following syntax.
    Thank you a thousand times Blux!

    =[ctn4].[column](3)
    1
  3. HELD_tokyo Posted messages 64 Status Member 1
     
    Attention

    I can modify the value of the combobox in column 2.
    So I have the value VEGETABLE or MEAT depending on my selection, and no longer HORSE or CARROT

    BUT I lose the initial value that I also need.

    I need both values in two different cells.
    0