Validating Form testing 2 Conditions

[Mel-4-short]

Hello,
I am trying to test whether or not:
If the field "Invoice" (i have an option button bound to it) is empty AND the TO: field is not equal to an address, then display error. Here's the latest code I've tried:

IIf(([To]<>"mailaddress") AND ([invoice]<>"")) OR (([to]<>"mailaddress")AND([Invoice]<>"")))

I've tried numerous ways without parenthesis, etc., but no luck. Is this even possible?
Thanks so much!

 

[Diane Poremsky]

If you are looking for an empty invoice field shouldn't this be = , not <> ?
[invoice]<>""

You're checking for 2 different addresses?

 

[Diane Poremsky]

Oh. It might be the double negative. If To does not = address1 OR it does not = address2, it's always going to pass, as one is always going to be true. (Plus, it might fail if there is more than one address in the to field. )

This seemed to work here (i didn't have an invoice field to check ) but then I remembered the double negatives. I am getting messages marked true.
IIf(([To]="address1" Or [To]= "address2") And [Last Verb Exec Type]="102","True","False")

This also seems to work, but i don't have a good test set so i could be wrong on the address expression.
IIf(([To]="address1" Or "address2") And [Last Verb Exec Type]="102","True","False")

If you need to use <> , try using 3 iif's
IIf( invoice = "", IIf(if to <> address1, "is true", iif(to <> address2, "is true", "is false"))

 

[Mel-4-short]

Thank you so much for the quick reply. I think I should have explained what I was doing better.
-I would like to have person 1, send an invoice approval form with an attachment to person 2. (Acctspay person)
-Person 2 approves (Click yes to pay & click yes to close PO).
-Person 2 forwards the form back to person 1 with their approvals (I need to validate and make sure 2 fields are not empty.)
-Person 1 forwards the form to person 3 with the approvals, the final resting place.

Issues I'm having:

I can use the easy validation method but when person 1 sends the form, it validates those fields and we don't want that quite yet. ONLY if the form is being sent to 1 of 2 addresses.

My workaround for that is I creating another form where the only change from a message form is that I called my Invoice Approval form on the forward action. The validation works beautifully, however, anything person 1 or 2 puts in the message field is not saved after forwarding (I'm assuming because it keeps calling a new Invoice Approval form).

My next thought is to go back to using 1 form, and trying to using a formula for my validation instead of just testing if it's empty.

So, I'd like to use the formua and 1 form. The formula I tried doesn't error but doesn't work either.

I so appreciate you and your help. Thank you!
-Mel
[DOUBLEPOST=1418135543][/DOUBLEPOST]IIf(([To]="mailaddress" Or "mailaddress") And [invoice]<>"")

The logic here seems correct, but doesn't seem to work...

 

[Mel-4-short]

Any other advice?

 

[Diane Poremsky]

I think you'll need to use 1 form and a formula. Unless you also pull in the message body field when you create the invoice form.