Add multiple fields to a table from 1 Combo Box ?

[ghnat]

Is it possible to add multiple field values displayed in a single combo box to a new table. Example ... if the Combo lists CustomerID (index visible)and CustomerName how can I take both fields and add them to a new table?

I know I can do it for the (bound) field but I'm at a loss as to the adding of the other field (CustomerName)

Any help would be greatly appreciated

Sorry ... I'm a bit of a newbie with Access

Thanks
Gary

 

[dalenz]

Hi ghnat,

You can place an invisible field on your form bound to Customername.

On the after update event of the combo box CustID:

me![Customername] = me![CustID].column(1)

Just remember that the columns start at 0, ie if you set columns visible property to 2 it is not column 1 and 2 but 0 and 1.

 

[ghnat]

It worked!

Thank you! Thank you! Thank You!

ghnat