Basically what I need is a button to select one or the other option. Like on and off but when ON is selected if will clear OFF and viceversa. I thought this was what I needed but it won't work.
Private Sub InCollection_Click()
If InCollection = True Then
[Wishlist] = Null
Else
If Wishlist = True Then
[InCollection] = Null
End Sub
Thanks.