I looked through the past threads but could not find this problem.

This is the setup.

I have a combo box with

control.source = myfile1.myfield
rowsource = myfile2.lookupfield1
rowsourcetype = fields

Myfile1 has preexistant data and on some of the records the value in myfield do not match any of the values in myfile2.lookupfield. When I display records that have matching values the combo box shows the value of myfield but when I select a record that is not contained in myfile2.lookupfield the combo box displays nothing. Am I missing a setting somewhere?

TIA
Robert