Use combo box to fill multiple fields

[jlindquist23]

I'm using a combo box to fill in multiple fields in my form using the on change command:


Private Sub cboItemNo_Change()
Me.txtRC_LCL.Value = Me.cboItemNo.Column(1)
Me.txtRC_UCL.Value = Me.cboItemNo.Column(2)
Me.txtSagePotTemp.Value = Me.cboItemNo.Column(3)
Me.txtSageQTemp.Value = Me.cboItemNo.Column(4)
End Sub

I'm not sure why it will only use 3 of the 4 columns. Is there a limit on columns? I changed to column numbers on these two lines to see if it was my formula:
Me.txtSagePotTemp.Value = Me.cboItemNo.Column(4)
Me.txtSageQTemp.Value = Me.cboItemNo.Column(3)

An then the QTemp started filling and not the PotTemp. Again...Columns 1 - 3 work. It's when I add a 4th.
Thanks for the help!!

[Minty]

Combo column numbering starts at (0) being the first column.

Is that your issue ?

[jlindquist23]

The zero column is the key column. Then there is 4 columns of data after that.

[jlindquist23]

It was the column count in the combo box. I had it set at 3. When I set it to 4, it worked!!!

[Minty]

Glad you sorted it

[Gicu]

And I would suggest you move the code to the AfterUpdate event of the combo-box as OnChange fires for every keystroke.
Cheers,
Vlad