i get a else without if statement when running if statment

[at51178]

Hey guys
I believe I am writing this right but I get a else without if error message anyone can help me with this here is the code.

If optLastName.Value = 1 And OptFirstName.Value = 0 Then Me.RecordSource = "SELECT tblmain.LastName, tblmain.firstName " & "FROM tblmain " & "WHERE tblmain.LastName LIKE '*" & txtSearch & "*';"
Else
If optLastName.Value = 0 And OptFirstName.Value = 1 Then Me.RecordSource = "SELECT tblmain.LastName, tblmain.firstName " & "FROM tblmain " & "WHERE tblmain.FirstName LIKE '*" & txtSearch & "*';"
End If

 

[at51178]

I figured out the problem the option buttons are in a frame and for some reason it didn't work.
I created two more option buttons out of a frame and it worked perfectly.
here is the code

If Option13.Value = True Then
Me.RecordSource = "SELECT tblmain.LastName, tblmain.firstName " & "FROM tblmain " & "WHERE tblmain.LastName LIKE '*" & txtSearch & "*';"
ElseIf Option15.Value = True Then
Me.RecordSource = "SELECT tblmain.LastName, tblmain.firstName " & "FROM tblmain " & "WHERE tblmain.FirstName LIKE '*" & txtSearch & "*';"
End If

 

[Transcend]

Ok well I assumed the option buttons were directly on your form. To use option buttons on a frame you would have to reference the frame first.

if frame1.option1.value = true ...


Transcend