>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?
No, it's normal. Combo will show only values that exist in rowsource. If you want to show something wich is not there, then you must set Combo.Style=0 (in design time) and Combo.DisplayValue=myfile1.myfield (in run-time after each move of record pointer).
Edward Pikman
Independent Consultant