combo box does not show data after value/record is selected from l

[Boris]

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.

 

[Wayne-I-M]

Hi you need to change your column withds.

You don't say what they are at the moment

 

[Boris]

Thanks. The withds of the column are big enough for the data to show, if
thats what you mean. Just got to thinking, my problem can be fixed with a
statement, since my drop down list is filtered with a selection querie, so
the records that are not showing (the one already picked) no longer meet the
criteria. Been trying to build a Is null expression, but still have not found
the correct order for things, as if to say:

=IIf(IsNull([idinm]),[to show the results of selection query in combo box],
[expression to show current record display if [idinm] is not zero])

still working on it and were to put this expression, I mean if it has to be
put in the selection querie of the data propertie of the combo box or
somewere else