Passing the value of a Combobox to another field.

A

Aaron

I have a combo box ("ComboLineDefault") that is looking at table
"ProductionLines" which has 2 fields (Record ID and Name" The combo box
shows the "Name" but I want to be able to pass this value to another field on
the form.

I have this code written but is passes the value of the "Record ID" not the
"Name".

lineid.Value = ComboLineDefault.Value

Thanks in Advance,
Aaron
 
M

Maurice

Aaron,

You should refer to the proper column of the combo. In this case it's column
1. The combo starts zerobased so the first value is the default being column
0.

lineid=combolinedefault.column(1)

should do the trick.

hth
 
Top