In MS Access 2013, I have a combo box on a form. It pulls two values, Name and ID (from Client table). It stores ID but displays Name. The query behind it is to only shows Names that have a status of Active. However, when a Name is set to inactive, it no longer displays the name in the field. The field source is set to ID (from the Claim table). I would think the field source would read from the claim table record, not from the row source on the combo box. I remember that there are some odd things that can happen with combo boxes. Any ideas how I maintain my unique row source, but display the name if the Client is inactive?