Restrict Combo Box

[Lynn_AccessUser]

I have a combo box with 2 values the user can choose from.

Value A
Value B

I need to prevent the user from choosing Value A more than once on a continuous form. For example, they may enter in 3 people on the form. Each person must then be assigned a value. However, only one person can be assigned Value A. Any number of people can be assigned Value B.

Thanks!!!

 

[llkhoutx]

After you used a value, change the combo box recordsource.