Option Group Validation rules question (how to turn off)

  • Thread starter Thread starter Dirtbike
  • Start date Start date
D

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.
 
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

__________________________________
 
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
 
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.
 
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

__________________________________
 
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!
 
Back
Top