Without seeing your dB, it sounds like your combo box is unbound.
I would have guessed the opposite, and that the records are on a continuous or datasheet subform (or possibly a split form). As you probably know, there is only 1 original control on a continuous form - the rest are 'copies'. Change one, and they all change (when they are bound). Usually combos that filter records should not be bound, especially on a continuous/datasheet form.
Last edited by Micron; 04-23-2019 at 06:37 PM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.