Tabular form uses combobox column ref

[Lulu]

I've done this before,but for the life of me I cannot find my notes on how I
did it.

Have a tabular subform which has a combobox. Want to have an unbound text
box that refers to value in one of the combo boxes hidden columns.
me!txtBox=me!cboList.column(1)

works fine for signel records

Problem is on multiple records unbound text box displays same info for all
records.
example: combo box=1 unbound=red
combobox=2 unbound=red when it is supposed to say blue

What have I forgotten to do?

 

[MacDermott]

Your problem is that Me!cboList refers to the value in the currently
selected record, and this is the same for all records, until you change the
selected record.

Perhaps a DLookup would work for you.
Or you could simply include the table that feeds your combobox in the query
you've based your subform on...