Another Problem

[scorpio_x73]

I have a combo box witch holds products from table products
but in table products i have also color and size for every product

In my main form i select products,but i want also to show in the form in a plain text box the size and the color

can this be hapen, i tried with this code from another post but still ca't do it

Me.textField=Me.textField & Me.comboBox


Thanks again in advance

 

[neileg]

Include these extra fields in your combo box. If you don't want the user to see them there, set the column width for these to zero. Them you can refer to these columns in the text boxes you want. Look up Column Property in Access help.