combo box not picking up records with null fields

[Allilue]

hi,

i have a form with a combo box where you can select a Code. There are 2 subforms on this form which both have this Code field, and other fields as well. for the most part, when i select a specific Code, the records will be displayed on the subforms. I think the problem is that some Codes have null values within the records where no data is available, and these records will not display. the combo box is only looking up the Code, and not the other fields. For these records with null fields, the subform will not show these records and will jump back to the first record by default.

is there a way around this, so that all records will show, regardless of if there is a null field within the record or not?

thanks!