Hi all.

I'm working on a "Manage Form" in SLX LAN v7.2.1.

And I'm trying to do an if-else statement using the LIKE operator but it's not working I keep getting the following error: "Sub or Function not defined" and it's saying the error is the If statement. Is there an equivalent of LIKE that I can use?

Thank you in advance.

Sub cmbCompetitorChange(Sender)

If cmbCompetitorTier.Text Like "GC%" Then

Msgbox("Information Saved")

Else

Msgbox("Start Again")

End If

End Sub

Nevermind I figured it out using InStr().

If InStr(cmbCompetitorTier.Text,"GC")>0 Then

Msgbox("Information Saved")

Else

Msgbox("Start Again")

End If