I have 2 Yes/No fields on a form: Forecast and BackUp. If forecast is checked and they try to check BackUp I need a message that says only one can be checked at a time.
I thought it might be an If statement in the After Update Event of each field like
But I cannot seem to get the Else to work as expected - basically if the other field is not Yes then let them check the box to set it to Yes.Code:If Forecast = "Yes" Then MsgBox "Only one can be checked at a time" Else: End If
Can you help with this part of the statement - if this is even the right way to go. I need to store each value in separate field which is why I am going this way and not a group or toggle.
Thanks as always