Checkbox and multiple pages

[Aggie G]

I have a custom form in Outlook and I need help. This is what I want. If the
'Policy/Procedure' checkbox is checked, the form will require the user to
complete specific fields on a different page (Procedure Details) of the
Outlook custom form. The validation formulas in the fields on the procedures
detail page should only apply when the box is checked.

I think this would require VBA, but I am not experienced enough to do this.
Please help.

 

[Eric Legault [MVP - Outlook]]

You can monitor the CustomPropertyChange event and check the Name parameter
to make sure it equals the field you have bound to the checkbox. If it is
true, call Inspector.ShowFormPage("PageName") to display your page.

However, you can't toggle any validation checks for a control with code.
You'd have to code the validation logic yourself and implement it in the
CustomPropertyChange event, setting Cancel=True if the logic test fails with
the current value.

 

[Aggie G]

Ok this sounds like I need to write code to bound the checkbox to the
specific page; problem is I don't write code. Can you provide me with code to
do this ?

 

[Guest]

If it's your job to create custom Outlook forms, it is in your best
interests to learn the basics of Outlook coding! There are plenty of
resources out there - it's best to start with http://www.outlookcode.com.
If you can start, I'll assist you with specific questions but I don't have
time to code your entire solution - sorry.

Eric

 

[Aggie G]

Actually it isn't my job to create forms, I do it to make it easier on
myself. If you don't have time to help me, that is fine...I'll try to figure
it out myself!

 

[Sue Mosher [MVP-Outlook]]

The checkbox needs to be bound to an Outlook property (call it MyField for purposes of this example). The validation formula for each other field would be:

([MyField] = False) OR ([OtherField] <> "")