Tabular form uses combobox column ref

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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...
 
Back
Top