I have a combobox (Style=0) that populates from a table (RowSourceType=2 RowSource="Table_A.Field").
In the ControlSource I specified another table field (ControlSource="Table_B.Field"
When I start my form, i'm in a blank record from Table_A. If a select a option in the combobox list, after selecting the displayvalue is empty, and the value the same. If a see the record nothing was stored there.
If I remove the controlSource then I can see the selected option in the combobox.
I need to code {"REPLACE table_b.field WITH THIS.VALUE} in the programmatic change event to store the picked option from the combobox in the table.
Why Is that happening?
With a textbox if I specify the controlsource="table_a.field" and by code { this.value="ABC", the "abc" value is stored in the "table_a.field". Why the combobox is not working the same way?