Option Buttons

[lenin42001]

If Option1.Checked = True Then
Text1.Text = "Management"
ElseIf Option2.Checked = True Then
Text1.Text = "IT"
ElseIf Option3.Checked = True Then
Text1.Text = "Clerical"
ElseIf Option4.Checked = True Then
Text1.Text = "Canteen"
End If
If Option5.Checked = True Then
Text1.Text = Text1.Text + "(Male)"
Else
Text1.Text = Text1.Text + "(Female)"
End If
End Sub
Can someone come to our assistance please. Have entered aforementioned code which relates to 5 option buttons into the click data entry portion of command button. However msg box comes up warning of syntax error every time the command button is pressed. The command line code is in yellow & the word checked is in blue. I've checked the microsoft help site but the code seems to be OK. We're totally lost............

[iburyak]

Try this:

[PHP]
If Option1.Value = True Then
Text1.Text = "Management"
ElseIf Option2.Value = True Then
Text1.Text = "IT"
ElseIf Option3.Value = True Then
Text1.Text = "Clerical"
ElseIf Option4.Value = True Then
Text1.Text = "Canteen"
End If
If Option5.Value = True Then
Text1.Text = Text1.Text + "(Male)"
Else
Text1.Text = Text1.Text + "(Female)"
End If[/PHP]