if statment problem

[Agnes]

Simple question: If Me.strPosttype ="ACCT" or Me.cboDocType.Text.Trim ="M"
, It should ignore the checking point .However, I found that I can do it.

If (Me.cboDocType.Text.Trim) <> "M" Or Me.strPostType <> "ACCT") Then
.........checkingpoint
end if

Now, I change my syntax into the following, the problem is solved. but
anyother simple way to do that.
If (Me.cboDocType.Text.Trim) <> "M" then
IF Me.strPostType <> "ACCT") Then
.........checkingpoint
end if
end if

 

[Ken Tucker [MVP]]

Hi,

You should use and instead of or because you want both conditions to
be true.

If (Me.cboDocType.Text.Trim) <> "M" And Me.strPostType <> "ACCT") Then


Ken
-----------------------------
Simple question: If Me.strPosttype ="ACCT" or Me.cboDocType.Text.Trim ="M"
, It should ignore the checking point .However, I found that I can do it.

If (Me.cboDocType.Text.Trim) <> "M" Or Me.strPostType <> "ACCT") Then
.........checkingpoint
end if

Now, I change my syntax into the following, the problem is solved. but
anyother simple way to do that.
If (Me.cboDocType.Text.Trim) <> "M" then
IF Me.strPostType <> "ACCT") Then
.........checkingpoint
end if
end if

 

[Cor Ligthert]

Agnes,

If (Me.cboDocType.Text.Trim) <> "M" then
IF Me.strPostType <> "ACCT") Then
.........checkingpoint
end if
end if

The syntax above is
If Me.cboDocType.Text.Trim <> "M" AndAlso Me.strPostType <> "ACCT" Then

Not Or

I hope this helps,

Cor

 

[Herfried K. Wagner [MVP]]

Simple question: If Me.strPosttype ="ACCT" or Me.cboDocType.Text.Trim
="M" , It should ignore the checking point .However, I found that I can do
it.

NOT(A OR B) <-> NOT(A) AND NOT(B)

<-> ... logically equivalent.

=>

\\\
If Me.strPosttype <> "ACCT" AndAlso Me.cboDocType.Text.Trim() <> "M" Then
...
End If
///

 

[Phill. W]

Simple question: If Me.strPosttype ="ACCT" or
Me.cboDocType.Text.Trim ="M" , it should ignore the
checking point.

How about this?

If Me.strPosttype = "ACCT" _
Or Me.cboDocType.Text.Trim = "M" _
Then
' Ignore the checking point
' Do Nothing - (my favourite comment)
Else
' checking point
End If

HTH,
Phill W.