Make a text box entry mandatory dependant on Option Group Selection

[kickergirl]

I am creating a rather unwieldy database (MS Access 2000) in which the client wants to provide the users with an "Other" option for every option group. The client also wishes the user to explain what "Other" is. How do I make sure that the client enters the explanation?

I have tried the following in AfterUpdate, On LostFocus, and On Exit. But nothing works. I have never tried to code events on option groups and am finding it very difficult. Any assistance will be appreciated.

Thanks!

 
If [OptionGroup] = 4 And [txtbox] = Null Then
   MsgBox "Please provide explanation for 'Other'. "
End If
 
 

[Scott Price]

Have you made sure that the Option Group frame is named and spelled correctly in your code?

Generally speaking, also, you would want to designate which form it resides on:

Me!...
Forms![FormName]

Are two ways. The first is when the code resides in the form module that is executing the code. The second when it resides in another module.

Regards,
Scott

[missinglinq]

Where the name of the option frame is OptionGroup (and is bound to a numerical field in the underlying table) and the text box is named OtherExplanation

Private Sub Form_BeforeUpdate(Cancel As Integer)
 
 If Me.OptionGroup = 4 And IsNull(Me.OtherExplanation) Then
    MsgBox "Please explain 'Other'. "
    Cancel = True
    Me.OtherExplanation.SetFocus
 
  End If
End Sub 

Linq ;0)>