Option Box Rule

  • Thread starter Thread starter Stockwell43
  • Start date Start date
S

Stockwell43

Hello,

I have an Option Box on my form that gives the user two choices: "Closing"
of "Doc Prep". I want to FORCE the user to select one of the two choices in
the Option otherwise it will not allow them to save the record(so in
otherwords, I don't want the option box blank or Null). Now I know I can do
this by selecting the Required field in the main table but I also need a
message box to pop up to "You must select either Closing or Doc Prep". I
don't know how to add that in if I use th required field. I was hoping
someone knew how to do all this in VBA and when I would place the code. Any
help would be most appreciated.

Thanks!!!
 
Hello,

I have an Option Box on my form that gives the user two choices: "Closing"
of "Doc Prep". I want to FORCE the user to select one of the two choices in
the Option otherwise it will not allow them to save the record(so in
otherwords, I don't want the option box blank or Null). Now I know I can do
this by selecting the Required field in the main table but I also need a
message box to pop up to "You must select either Closing or Doc Prep". I
don't know how to add that in if I use th required field. I was hoping
someone knew how to do all this in VBA and when I would place the code. Any
help would be most appreciated.

Thanks!!!
Click to expand...

Code the Form's BeforeUpdate event:

If IsNull([OptionGroupName]) Then
MsgBox "Gotta pick one or the other"
Cancel = True
End If
 
Hi Fred!

Thank you very much for your help. Code works great!!

fredg said:
Hello,

I have an Option Box on my form that gives the user two choices: "Closing"
of "Doc Prep". I want to FORCE the user to select one of the two choices in
the Option otherwise it will not allow them to save the record(so in
otherwords, I don't want the option box blank or Null). Now I know I can do
this by selecting the Required field in the main table but I also need a
message box to pop up to "You must select either Closing or Doc Prep". I
don't know how to add that in if I use th required field. I was hoping
someone knew how to do all this in VBA and when I would place the code. Any
help would be most appreciated.

Thanks!!!
Click to expand...

Code the Form's BeforeUpdate event:

If IsNull([OptionGroupName]) Then
MsgBox "Gotta pick one or the other"
Cancel = True
End If
Click to expand...
 
Back
Top