Validating frames, how??

[uttam1]

Hi all,

One more problem, I have a frame with 2 option buttons ( radio buttons )There is no default value. I want to validate the frame and make sure a value is selected before it enters the database. Each option's have index's 1 and 2. How do I do this?

Thanks in advance,
Uttam

 

[VBslammer]

Just check the frame to see if it's null:

Private Sub Form_BeforeUpdate(Cancel As Integer)
On Error GoTo ErrHandler
  If IsNull(Me.fraOptions.Value) Then
    MsgBox "Please choose an option"
    Cancel = True
  End If
ExitHere:
  Exit Sub
ErrHandler:
  Debug.Print Err; Err.Description
  Resume ExitHere
End Sub

VBSlammer

Unemployed in Houston, Texas