I am working in a subform in datasheet view with the following fields: vendor, vendor contacts. When the operator selects a vendor, the appropriate contacts related to the vendor should be populated in the vendor contacts combo box. I know that I can change the Row Source property to reflect all of the vendor contacts available for that particular vendor; however, all vendor contacts fields that do not relate to that particular vendor disappear. This also happens when the form is set to continuous.<br><br>After some contemplation, I realize that I could manually populate the combo box and include all of the non-relating vendor contacts but this would allow the operator to select a vendor contact that does not relate to the vendor selected in the previous field.<br><br>I would greatly appreciate any advise.<br><br>