I have a master detail form. The subform contains unbound columns alongwith bound columns.

The fields on the subform are "ItemCode","Item Description", "Colour" and "Size".

"Itemcode" is a combobox and is bound to a table and all other fields are unbound text fields.

When I select ITEM1 in the combobox it displays the Desc, Colour and size correctly in the other unbound text fields in the same row. However when i go to the next row and select ITEM2, it displays the Desc, Colour and size of ITEM2 but also overwrites Desc, Colour and size text fields of ITEM1 with that of ITEM2.

I'm sure there must be a soltion to this but I just cant figure it out. Help appreciated. Thanks