Form Displaying Wrong Column

[BellKev]

Hello ... I have a lookup field with 3 columns. The correct column is getting stored on the base table, However the field on the form is displaying the ID number ... not the actual field data ... I know this is really easy to fix, I'm just having a mental block this afternoon ...

Kevin

 

[PHV]

Have a look at the ColumnWidths property of the ComboBox object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[BellKev]

Hmmm ... still not fixed ... the combo box object seems to be displaying column 1 ... It would appear that I'm having difficult displaying column 2 (Which contains my meaningful data) ...

 

[PHV]

In fact, the combo box object display the first column having a width different from zero.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[BellKev]

And there it is ... thanks much ... just as a matter of curiosity ... what if I wanted to display the 3rd column ??

 

[ZOR]

Use the columncount property, ie insert the number of columns you want to be visible. In the columnwidths, enter the widths you want seperated by semicolons. If you wanted not to see one of the columns, then enter a zero.

 

[67peshawar294]

bellkev,
if your info is in the second column,in the record source of the txtbox place
=[yourcomboboxnumber].column(1)
the columns are numbered 0,1,2,3,4...
jim

 

[TheAceMan1]

How are ya BellKev . . .
[ol][li]The [blue]Bound Column[/blue] property determines which column is stored.[/li]
[li]The first [blue]non-zero column[/blue] in the [blue]Column Widths[/blue] property, is the display field.[/li][/ol]

See Ya! . . . . . .

 

[BellKev]

Thanks guys ...