In Microsoft Access, how would you create a pair of fields (call them 1A and 1B), such that 1A is a yes/no field and 1B is a text field which must have data if 1A=Yes and must be blank is 1B=no, as in the following:
**1A:** Did the mama see anything? [ ] Yes [ ] No **1B:** If yes, what did the mama see? _______________________
Importantly, I would like it so that changes to either field cause the relevant conditions in the other field to be evaluated as well. Thus, if you initially set 1A = Yes, enter data in 1B, and then change 1A to No, then 1B will be blanked out. Likewise, I would like it to require an entry in 1B whenever 1A=Yes.
If I am not mistaken, the above means that the conditions must be evaluated at the Before Update event. How do I tell Access to do so and to do so at that time? Or maybe there is a better way to capture these formal requirements altogether?