Option Group Validation rules question (how to turn off)

[Dirtbike]

Folks:

I have changed a form in that I don't care about a particular option group
anymore. I don't have any validation rules set at the table level but when I
try to create a new record it pukes my message about "you must have a
selectuion in engine family".
I'm about 2 hours into how to turn off the validation rule and about to pull
my hair out.
I don't see where on the form I have a rule. I don't see how to "select"
the option group.

Thank you very much for your help here.

 

[boblarson]

If you have set a composite key in the table then that would do it too. Or,
it could be set in your relationships by having Cascade Delete set for a
field for which it isn't important to do cascade deletes.
--
Bob Larson

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[Klatuu]

Have you checked the field level of the table for a validation rule?
Have you checked the form before update event for code that might present
the message? Same for the before update event of the optiongroup control

 

[Dirtbike]

Have you checked the field level of the table for a validation rule? Yes and
there is not a validation rule there.
Have you checked the form before update event for code that might present?
Yes, I don't see any before update code.

the message?

Same for the before update event of the optiongroup control...therin lies
the rub, I can't seem to call up the option group as an option group. It's
either labels or some such.

 

[boblarson]

If you still can't get it to work, you can email your db to me (remove any
sensitive or personal information) at accessbob [a][t] gmail dot [com] (email
obscured to avoid email spam.

Be sure to include a description of the problem again so that I know what it
was about as I get alot of email about different problems.
--
Bob Larson
Access MVP
Free Tutorials at http://www.btabdevelopment.com

__________________________________

 

[Dirtbike]

I'm such a goof. Had I actually read and understood the error....it actually
said "Required Value set to Yes"...so it wasn't a real "validation rule"
deal...

Thanks.

Special thanks to the dude who helped me actually figure how to in effect
"select" the option group.

Thanks again!