Why not just have the user pick from a combo and control this by design rather than vba code? A table for valid values for the observations could be the row source for the combo, or one table per combo. Impossible to say without knowing more. I'm guessing there is something about each record that could filter or build the list items so that 1 or 2 isn't in the list when Pass or Fail are the appropriate choices. It appears that this is a continuous form so I think that would be important.
Or can you not control the row source of individual combos in a continuous form? If not, then I think controlling the type of data for individual textboxes on a continuous form would be just as problematic, no?
Last edited by Micron; 09-13-2018 at 07:51 PM.
Reason: added questions
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.