comparison <>

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the codes as following.
If (IsNull(Me.CLASS.Value)) Then
lblPrompt.Visible = True
Me![Subform].Visible = False
ElseIf Me.CLASS.Value <> "ClassName*" Then
lblPrompt.Visible = True
Me![Subform].Visible = False
ElseIf Me.CLASS.Value Like "ClassName*" Then
lblPrompt.Visible = False
Me![Subform].Visible = True
End If

When I debug the code, suppose the [Class] does have ClassName* that match
the third (3) case. I don't know why the execution does not skip ElseIf
Me.CLASS.Value <> "ClassName*" Then. (it should skip this case)

I suspect the <> sign is used incorrect. Can you please tell me why it
happens and how can I fix it?

Thank you very much for your help in advance.
tim
 
<> doesn't use wildcards. Change the order of your statements:

If (IsNull(Me.CLASS.Value)) Then
lblPrompt.Visible = True
Me![Subform].Visible = False
ElseIf Me.CLASS.Value Like "ClassName*" Then
lblPrompt.Visible = False
Me![Subform].Visible = True
Else
lblPrompt.Visible = True
Me![Subform].Visible = False
End If

(There's no reason to check for <>, since you already know it's isn't Like
"ClassName*")
 
Back
Top