Not all values being copied across to table.

[MCCDOM]

Hi there,

I am having a little trouble copying all the values from a combobox row to a table. It seems to miss out the last two columns but copies the first two across fine. Why is this, is there a limitation to how much can be copied from one row of a combobox?

The code I am using is:

CurrentDb.Execute "INSERT INTO tblAllocated (StockID, Item, Make, Model, FirstName, LastName, OfficeName) VALUES ('" & Me.cboStockID.Column(0) & "','" & Me.cboStockID.Column(1) & "','" & Me.cboStockID.Column(2) & "','" & Me.cboStockID.Column(3) & "','" & Me.cboName.Column(1) & "','" & Me.cboName.Column(2) & "','" & Me.cboOffice & "')"

The StockID column 0 and 1 are copied to the table fine but columns 2 and 3 are left blank on the table.

The combobox is unbound and uses rowsource to select the 4 data values (StockID, Item, Make and Model).

Your help resolving this would be very much appreciated.

[amrut]

Are you sure the Column Count for the Combo is 4 ?

[MCCDOM]

Thanks, I completely overlooked that. Column count was set to 1 so changed it to 4 and set the last 3 column widths to 0cm.