Prev: Disabling and Re-enabling Keys
Next: Share my database
From: Aaron on 22 Mar 2010 15:06
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


From: Maurice on 22 Mar 2010 15:11
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
>
>
 | 
Pages: 1
Prev: Disabling and Re-enabling Keys
Next: Share my database