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
-- 
Maurice Ausum


"Aaron" wrote:

> 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
> 
>