I have a combobox tied to tableA with the following properties:

RowSource = tableA.field1
RowSourceType = 6 - Fields
ControlSource = tableB.anotherfield
BoundColumn = 2
BoundTo = .T.

tableB has BufferModeOveride = 2 - Pessimistic Row
tableA is not buffered

I am trying to populate tableB.anotherfield with the values from tableA.field2 (so that BoundColumn = 2).

I am able to see the values from tableA.field1 in the pulldown. My problem is that instead of containing the value of tableA.field2 as I thought it would, the value property of the combobox is empty, even after I do a refresh() and requery() in the valid event of the combobox.

I need the values from tableA.field2 internally before I do a tableupdate().

Can anyone please tell me what I'm missing? Thank you.