Multi Column Lookup Wizard Display 3 columns change which one is shown on table

[DBnub11]

Hi All


I am doing a 3 column lookup wizard for my table in the form .
[Data from table] [Group Value] [lookup Value]


When I am finished it shows the Group Value. I want it to show the lookup Value. Any Ideas?

Thanks in advance.

 

[DCrake]

Columns are zero based so the first column is addressed as .Column(0)

 

[DBnub11]

ok is there any way I can alter the lookup wizard to change the column number once it is set up? In the wizard I do not think they give me an option of specifying this.

 

[boblarson]

You don't need the wizard. Open the form in design view, click on the combo box. Then in the properties dialog you go to the FORMAT tab and change the ColumnWidth property to what you want. If you want the first column to show you change the 0" to something else like 1" (or 1 cm if you are using metric).


So, if you have 3 columns and you want them all to show you would have

1";1";1"

if you have 3 columns and you want the first and third to show you would use

1";0";1"

 

[DBnub11]

its not on a form its on the table itself so I cannot go into the properties at all

 

[boblarson]

its not on a form its on the table itself so I cannot go into the properties at all

1. You should NOT be using lookups directly in tables as they are EVIL (see here for why).

2. There still are properties for a lookup in a table. They are the same as I've mentioned and they are on the Lookup tab in the table.

3. But you should really not use them in tables but on forms.

 

[DBnub11]

The lookup fields in the table is instrumental to my input form

whats a resonable alternative