Required fields on separate tabs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jackie - 21 Aug 2006 23:11 GMT

I have 4 tabs on a form.. There are some fields on the each tab that are
required but not all tabs are required to be completed.. what do I need to do
to enable the required fields on the tabs selected?

thanks for your help
jackie

Reply to this Message

Sue Mosher [MVP-Outlook] - 21 Aug 2006 23:34 GMT

It's unclear why you would want to enable certain controls or under what conditions. What more can you tell us about your application?

Signature

Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

>I have 4 tabs on a form.. There are some fields on the each tab that are
> required but not all tabs are required to be completed.. what do I need to do
> to enable the required fields on the tabs selected?
>
> thanks for your help
> jackie

Reply to this Message

Jackie - 23 Aug 2006 15:12 GMT

Sue,
The form is a request form.. There is a general tab for generic info and the
other tabs are situational, one for presales, one for delivery and one for
solutions support.. everything on the general tab is required, but the others
are situationally required.. I can only enable the required fields on the
general tab..If you require presales help, then you complete the presales
tab, if you require a delivery you complete the delivery tab, etc.. no one
will ever need to complete all of the tabs at one time..

I hope this makes sense..
thanks
jackie

> It's unclear why you would want to enable certain controls or under what conditions. What more can you tell us about your application?
>
[quoted text clipped - 4 lines]
> > thanks for your help
> > jackie

Reply to this Message

Sue Mosher [MVP-Outlook] - 23 Aug 2006 15:32 GMT

You say you can only enable the firles on the general tab. What happens when you try to enable others? Show the relevant code snippet and point out which statement raises an error.

Signature

> Sue,
> The form is a request form.. There is a general tab for generic info and the
[quoted text clipped - 10 lines]
>
>> It's unclear why you would want to enable certain controls or under what conditions. What more can you tell us about your application?

>>
>> >I have 4 tabs on a form.. There are some fields on the each tab that are
[quoted text clipped - 3 lines]
>> > thanks for your help
>> > jackie

Reply to this Message

Jackie - 25 Aug 2006 16:58 GMT

Sue,
I get the following error message:
A field on this form requires a value..

I do not have any code behind it except making the fields required. I am not
an outlook programmer, so I thought there might be an simple piece of code I
can put behind each tab.

thanks
jackie

> You say you can only enable the firles on the general tab. What happens when you try to enable others? Show the relevant code snippet and point out which statement raises an error.
>
[quoted text clipped - 20 lines]
> >> > thanks for your help
> >> > jackie

Reply to this Message

Sue Mosher [MVP-Outlook] - 27 Aug 2006 02:51 GMT

There is no code behind individual tabs. Code runs for the entire form. The symptoms suggest that you have used the Validation tab on some control's Properties dialog to make that control's field mandatory. Using the simple validation check box isn't recommended. The better approach is to use a validation formula and validation message for each control whose field you want to require.

Signature

> Sue,
> I get the following error message:
[quoted text clipped - 8 lines]
>
>> You say you can only enable the firles on the general tab. What happens when you try to enable others? Show the relevant code snippet and point out which statement raises an error.

>>
>> > Sue,
[quoted text clipped - 19 lines]
>> >> > thanks for your help
>> >> > jackie

Reply to this Message