I created a combo box whose data source are the fields of another table so
that I chose the value of that table in my main form to relate that record to
the record that I´m imputing on the main, everything works fine, it even
fills all the other fields that show up on the main form that are related to
the data on the record of the other table, the thing is that the value I
chose from the drop down list does not show in the form afterwards I select
it, it shows all other data related to that record but in the combo box from
which I chose it stays blank.
I have another combo box equal to this one on the same form but link to data
from another table, this one works fine and do show the value I chose all the
time.
In the first scenario I chose addresses and on the second only the names.