comboBox

[ShostyFan]

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.

[orange]

Can you post a zipped copy of your database?

[ShostyFan]

Very strange, I took out the relevant forms and tables and tried it out and Access gave me a compile error (didn't happen on my main database). From the compiler error i learned that the description field (3) was set to be only 10 char long....very strange because i have no reason to ever change that from the default 50. Anyway, that cleared it up, all is good.
still strange to me that it would no fill the 4th and 5th column.
sorry for the waste of time.

[orange]

Glad you have it sorted out.