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.

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.

--
Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Aggie G" wrote:

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.

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 ?

"Eric Legault [MVP - Outlook]" wrote:

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.

--
Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Aggie G" wrote:

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.

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" wrote in message
...
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 ?

"Eric Legault [MVP - Outlook]" wrote:

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.

--
Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Aggie G" wrote:

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.

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!

" wrote:

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" wrote in message
...
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 ?

"Eric Legault [MVP - Outlook]" wrote:

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.

--
Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Aggie G" wrote:

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.

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] "")

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Aggie G" wrote in message ...
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.