I have a combo lookup box that has 6 columns. On my form I have 6 fields that the combo box is to populate. For some reason only the first 3 fields are populating, the other fields remain blank. Here is my AfterUpdate:
Me.SerialNumber = Me.cmboSerialNumber.Column(0)
Me.Instrument = Me.cmboSerialNumber.Column(1)
Me.Size = Me.cmboSerialNumber.Column(2)
Me.Description = Me.cmboSerialNumber.Column(3)
Me.Replacement_Cost = Me.cmboSerialNumber.Column(4)
Me.RentalRate = Me.cmboSerialNumber.Column(5)
SerialNumber, Instrusment, and Size populate as expected.
I can't figure out what I am missing? the data types are also the same between the two tables, if that matters.