combo box and bound column

[DevAccess]

Hello

I have combo box with following table as bound as row source and columns

ID --> CustomerName--> CustomerID --> VendorName --> Invoice Number

So in control property I set column count =4 and column width = 0";2";2";2";2" and bound column =2 as I want to store CustomerID when I save recrod.

The combobox suppose to store customer ID while we save record as it is bound to column CustomerID of the form query.

Now when i create new record and save it saves as CustomerName as it is first column of the field.

But I want to store value as CustomerID even though they select customerName from combobox.

Please assist me what is missing.

 

[moke123]

column count = 5 as the property is 0 based.
i dont think the bound column is 0 based so it should be the actual count

 

[CJ_London]

you have 5 columns, so invoice number will not be in your combo

if you want to store the customerID then bound column should be 3