Combo Box Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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!
 
Jeep165 said:
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.
Click to expand...

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.
 
Back
Top