Passing the value of a Combobox to another field.

  • Thread starter Thread starter Aaron
  • Start date Start date
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
 
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
 
Back
Top