Validating Form testing 2 Conditions

Status
Not open for further replies.

Mel-4-short

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
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!
 
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"))
 
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...
 
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.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
V Validating Outlook form with "OR" and "AND" Outlook VBA and Custom Forms 1
R Validating a group of Checkboxes Outlook VBA and Custom Forms 2
G Apply Custom Contacts form to all existing Contacts Outlook VBA and Custom Forms 1
G Add Map It button to Custom Contacts Form in Outlook Outlook VBA and Custom Forms 1
G Outlook 2021 Add Picture to Custom Contact Form Outlook VBA and Custom Forms 2
P Can't add custom field to custom Outlook form, it always adds to the Folder instead Outlook VBA and Custom Forms 2
AndyZ Contact Custom Form Tiny Text Outlook VBA and Custom Forms 3
A How to reduce size of custom contact form? Outlook VBA and Custom Forms 3
L Applying new form to existing contacts -- MessageClass Outlook VBA and Custom Forms 3
Geldner Problem submitting SPAM using Outlook VBA Form Outlook VBA and Custom Forms 2
Witzker How to get the button Karte ( map) in custom contact form Outlook VBA and Custom Forms 2
B Outlook 2019 Custom Email form - Edit default email form Outlook VBA and Custom Forms 6
C Populate form data into message body Outlook VBA and Custom Forms 1
Witzker Outlook 2019 How to get a Photo in a User Defined Contact form Outlook VBA and Custom Forms 2
Witzker Outlook 2019 Macro to send an Email Template from User Defined Contact Form Outlook VBA and Custom Forms 0
Witzker Set Cursor & Focus from any field to the body of a user Contact form in OL 2019 Outlook VBA and Custom Forms 1
Witzker Place cursor at opening, a user defined OL contact form Outlook VBA and Custom Forms 3
T Customized form: The Forward option shows write layout Outlook VBA and Custom Forms 0
T 1:1 Datatransfer from incoming mail body to customs form body Outlook VBA and Custom Forms 0
V Latest Changes to form not appearing for some users Outlook VBA and Custom Forms 3
J Does the .fdm contain my custom form? How to make ol use it? - ol2007 Outlook VBA and Custom Forms 4
J ol2021 custom form not displaying pics Outlook VBA and Custom Forms 37
bdsermons Outlook 365 command button in outlook form Outlook VBA and Custom Forms 5
wayneame Changing the Form Used by Existing Task Items in a Folder Outlook VBA and Custom Forms 4
N Contact Form Notes Field Touch vs Mouse Using Outlook 0
cbufacchi Outlook 365 Populate custom Outlook Appoint form Outlook VBA and Custom Forms 2
C Create Meeting With Custom Form Outlook VBA and Custom Forms 2
W Designer Form 2013 and Script ? how ? Outlook VBA and Custom Forms 1
J Read Outlook Form fields Outlook VBA and Custom Forms 3
V Compound IF, OR, AND in Outlook form Outlook VBA and Custom Forms 4
J custom form not displaying pictures Outlook VBA and Custom Forms 7
I Button PDF in Outlook Contact custom form Outlook VBA and Custom Forms 1
K Font Sizing in Custom Form Regions for Contacts Outlook VBA and Custom Forms 1
M Outlook 2010 How could I globally redesign an outlook template form/region/inspector template used to display mail lists or an individual mails? Outlook VBA and Custom Forms 0
A How to stop user form from disapearing once mail window is closed? Outlook VBA and Custom Forms 0
K can't get custom form to update multiple contacts using VBA Outlook VBA and Custom Forms 3
V Form data not sending for some users Outlook VBA and Custom Forms 2
H Custom Outlook Contact Form VBA Outlook VBA and Custom Forms 1
Witzker HowTo Change message Class of contact form Outlook VBA and Custom Forms 0
A VBscript stops running after updating form Outlook VBA and Custom Forms 1
Witzker HowTo start a macro with an Button in OL contact form Outlook VBA and Custom Forms 12
D Emailed form is blank Outlook VBA and Custom Forms 0
F Validation on custom task form after task acceptance Outlook VBA and Custom Forms 1
C Add Form to Appointments Received, Automatically Outlook VBA and Custom Forms 6
V Date and/or time error in Outlook Form Outlook VBA and Custom Forms 0
A Form Position with Dual Monitors Outlook VBA and Custom Forms 2
I Error saving screenshots in a custom form in outlook 2016, outlook 365 - ok in outlook 2013, outlook 2010 Outlook VBA and Custom Forms 5
M VbScript for Command Button on Contacts Custom Form Using Outlook 1
G Other users can't see P.2 with custom fields in Form Outlook VBA and Custom Forms 0
O Create a custom contact form - questions before messing things up... Outlook VBA and Custom Forms 4

Similar threads

Back
Top