I don't know if the question is clear,
But let me explain
I have a couple of fields in Access. To explain I will show here the fields I have and their datatype
Basis info: Yes/No
Now, in the amendment field, I've inserted a combo box, with 3 options in it. Let's say option A,B and C
The thing I want access to do, is, when option C is selected, I want fields Period, Salary and Shift to be automatically "Yes"
But if option A or B is selected, the the user must choose what the other fields are going to be either Yes or No
Anybody can help me with this ??