If Value equals 2 fields

  • Thread starter Thread starter Amy Adams via AccessMonster.com
  • Start date Start date
A

Amy Adams via AccessMonster.com

I cannot sem to get code working for two values.
Here is my code:

If Me.Effective.Value = "N/A" Then
Me.ClsdNewPts.Value = True
Else

Me.ClsdNewPts.Value = False
End If
End Sub


This works great if value equals N/A the checkbox equals true. The problem
I have is that I would like the code to read:

If Me.Effective.Value = "N/A" Or "Pending" Then

After trying this line of code I get an error "Run time error 13 type
mismatch" How can I code for N/A or Pending to turn my checkbox true or
false?

Thanks for the help.
 
Back
Top