How to insert multiple option button which is on a frame into oracle database?

[senakudo92]

Hi All,I'm having problem with the frame, I try to insert the option button value which is on Frame 1 but it didn't store in database,it only store the value for Text1,Text2 and Text3. I'm new in VB,hope someone can help me, I'm really appreciate. Thank you =)

Dim con As New ADODB.Connection
Dim cmd As New ADODB.Command
Dim rs As New ADODB.Recordset
Dim cn As String
 
Private Sub CommandButton1_Click()
con.Open cn
cmd.ActiveConnection = con
con.CursorLocation = adUseClient
 
rs.Open "INSERT INTO TRY_REVISE(TRY, TRY_COMPONENT, TRY_CONDITION,TRY_STEP) Values ('" & Text1 & "', '" & Text3 & "', '" & Text2 & "','" & Frame1 & "')", con
 
Call Frame1
MsgBox ("Successfully Save")
End Sub
 
 
Private Sub Frame1_Click()
If Option1.Value = True Then
Value = "Reposition"
 
 Else: Option2.Value = True
Value = "Hold/Release"
 
 
End If
End Sub

[senakudo92]

I'm sorry,its already 1 week,hope someone who expert or have face the same problem to help me. I'm really appreciate it. I'm already google but I can't find about that.