Just received a message that one of my forms was not behaving properly. It seems that when someone seleted one of the option buttons in a set, more than one option would get selected. I said to myself, “This is not possible. You can only select one option at a time.”
Well, come to find out, I was right except for one minor detail. When I double clicked on one of the buttons in design mode to show me the value, I noticed that it had the same value as another option button. So whenever one was selected, both would populate and give the incorrect value. I changed the value and now all is well.
Moral of the story……make sure to triple check your values. It will cause a lot less grief down the road.