LIKE

[Guest]

hi,

I have the following, but I don't think it is being evaluated correctly:

ElseIf Me.prevstatus Like "pastdue*" And _
Me.todaystatus = "CURRENT" And _
Me.[Amended This Mo?] = 1 Or Me.[Extended This Mo?] = 1 And _
Me.[Paid Off?] = 0 And _
Me.[Active Inactive Flag] = "I" Then
With CodeContextObject
.pasted = "CURRENT BKAMD/DEF"
End With


For example, I think the following line:
ElseIf Me.prevstatus Like "pastdue*" And _
is not being evaluated correctly, because prevstatus can have a value of
"PASTDUE B4-50" or "PASTDUE A1-9"

I also think the following line:
Me.[Inventory Status] = "IN" Or Me.[Inventory Status] = "SO" Then
is being evaluated incorrectly. I would like to change it to something like:
Me.[fieldname] IN('IN','SO')
but I tried it and it did not work.

Also, do I need to change the following line:
Me.[Amended This Mo?] = 1 Or Me.[Extended This Mo?] = 1 And _
to:
(Me.[Amended This Mo?] = 1 Or Me.[Extended This Mo?] = 1) And _
so that it is evaluated as a single condition, or even correctly?

thanks in advance,
geebee

 

[Guest]

never mind...i figured it out.