If Or And statement possible...? (1 Viewer)

[ian_ok]

I'm trying to use the following but not sure if I am asking too much.

If Me.Ctl2nd_Payment_Payable = "Paid" Or Me.Ctl2nd_Payment_Payable = "Pagado" And IsNull(Me.Ctl2nd_Payment_Date_Paid) Then
MsgBox ("Error - Check the 2nd Payment details as it says PAID / PAGADO yet the date paid has not been added")
        Response = acDataErrContinue

If I take out the

Or Me.Ctl2nd_Payment_Payable = "Pagado"

Then it works, can I not do it so I only need one line of code rather than a new If for Paid and the Pagado?

Thanks

Ian

 

[SimonB1978]

Probably need some parentheses (bold red):

If (Me.Ctl2nd_Payment_Payable = "Paid" Or Me.Ctl2nd_Payment_Payable = "Pagado") And IsNull(Me.Ctl2nd_Payment_Date_Paid) Then
MsgBox ("Error - Check the 2nd Payment details as it says PAID / PAGADO yet the date paid has not been added")
Response = acDataErrContinue


HTH,

Simon B.

 

[ian_ok]

Thanks Simon always a simple way out, why didnb't I think of that....Doh...!!

Cheers Ian

 

[DCrake]

To simplify it eaven further

if Left(Me.Ctl2nd_Payment_Payable,2) = "Pa" ....