Although we usually think of Forms, and even entire Databases, when we speak of corruption, Controls, such as Option Groups, can and do become corrupted, and seem particularly susceptible to this during app development. The test/cure for this is short and simple...delete and then re-create the Control.
Also, I'm confused by this
Originally Posted by
Always_Learning
I have 2 option boxes referring to the same source and they do have values. They are different values for each option.
They are for time ie. early, afternoon, night for weekdays and early, afternoon, night for weekends.
Options Groups have Integers for Values...not Text, as you've indicated. The text associated with the Options is simply the Captions for their Labels.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007