VBA Code help

[Stephanie53]

I have Fields Form in this order:

SubpartID
PrimaryID
Discription
Qty
UnitCost
NetWght

Here is the VBA Code:

Private Sub cboSubpartID_Change()
Me.PrimaryID = Me.cboSubpartID.Column(1)
Me.Discription = Me.cboSubpartID.Column(3)
Me.Qty = Me.cboSubpartID.Column(4)
Me.UnitCost = Me.cboSubpartID.Column(5)
Me.NetWght = Me.cboSubpartID.Column(7)
End Sub

Now the SubpartID is not coming up at all...Its registering the PrimaryID instead. So I changed the Column# Still only getting the PrimaryID number instead the correct one. I changed the lookup on the Table...Still not able to get the SubpartID to show up in the form...


TIA For your Help!!

Stephanie

[June7]

Recommend AfterUpdate event instead of Change.

Make sure index references are correct.

Column() index begins with 0. So if the value you want is in column 2 the index is 1.