Combo Box Question

[Jeep165]

I have a combo box that lists the various positions in our department. The
positions are in their own table (PositionID, Position). I would like to add
a 3rd column to that table (PositionID, Position, PositionTimeMultiplier).

Ultimately I would like a text box to display the PositionTimeMultiplier on
a subform. But for now I would just like it to display something at all!
LOL I am trying to get it to display in a text box using

=cboPosition.column(2)

The combo box displays nothing (blank). But if I substitute "...column(1)"
it shows the position name as it should. The same goes for column(0). It
shows the positionID. I understand the colums are zero based. But why would
it not show the column 2 value?

I'm sure I'm missing a switch or a setting. But I can't figure it out.

 

[Jeep165]

WoooT! I figured it out. I was pulling the values for the combo box up
through a query. I just needed to update the query to include the new
column. Works like a charm now!

 

[Rick Brandt]

I have a combo box that lists the various positions in our
department. The positions are in their own table (PositionID,
Position). I would like to add a 3rd column to that table
(PositionID, Position, PositionTimeMultiplier).

Ultimately I would like a text box to display the
PositionTimeMultiplier on a subform. But for now I would just like
it to display something at all! LOL I am trying to get it to display
in a text box using

=cboPosition.column(2)

The combo box displays nothing (blank). But if I substitute
"...column(1)" it shows the position name as it should. The same
goes for column(0). It shows the positionID. I understand the
colums are zero based. But why would it not show the column 2 value?

I'm sure I'm missing a switch or a setting. But I can't figure it
out.

The third column has to be added to the RowSource of the ComboBox and you have
to set the ColumnCount property of the ComboBox to 3.