[AccessD] ValidationRule

Mark,
I think this happens if the main form is a bound form.... when moving into
the subform, Access performs an automatic save of the record and the
validation rules that you have placed in the table kick in.
Regards
Borge

----- Original Message -----
From: "Mark A Matte" <markamatte at hotmail.com>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, July 16, 2003 5:41 AM
Subject: RE: [AccessD] ValidationRule


> Charles,
>
> When I try to click on the subform...or one of its fields...the validation
> rules of the main form's tables are enforced.
>
> Thanks,
>
> Mark
>
> Also, I tried to use the validation rules on the form instead of the
> table...but I don't know when they are inforced...whith all the rules on
the
> form...it lets me save no matter what.?
>
>
>
> >From: "Wortz, Charles" <CWortz at tea.state.tx.us>
> >Reply-To: Access Developers discussion and problem
> >solving<accessd at databaseadvisors.com>
> >To: "Access Developers discussion and problem
> >solving"<accessd at databaseadvisors.com>
> >Subject: RE: [AccessD] ValidationRule
> >Date: Tue, 15 Jul 2003 14:32:34 -0500
> >
> >Mark,
> >
> >Are you saying that whenever you open the form that the subform is
> >displaying some data that does not conform to the validation rules you
> >have placed on those fields in the table?  This should not happen if the
> >subform is displaying existing data that is clean.  However, if it is
> >showing a new record without proper default values already filled in,
> >then it will complain.
> >
> >Charles Wortz
> >Software Development Division
> >Texas Education Agency
> >1701 N. Congress Ave
> >Austin, TX 78701-1494
> >512-463-9493
> >CWortz at tea.state.tx.us
> >
> >
> >
> >-----Original Message-----
> >From: Mark A Matte [mailto:markamatte at hotmail.com]
> >Sent: Tuesday 2003 Jul 15 14:16
> >To: accessd at databaseadvisors.com
> >Subject: [AccessD] ValidationRule
> >
> >Hello All,
> >
> >In A97 I have a form with a subform.  I am using the Validation Rule in
> >the
> >tables to require certain fields.  Everytime I try to go to the
> >subform...it
> >tries to enforce the ValidationRules.  Is there a way to keep this from
> >happening until saving?
> >
> >Or a suggestion on how to require a field with out coding each one
> >individually on save?
> >
> >Thanks,
> >
> >Mark A. Matte
> >_______________________________________________
> >AccessD mailing list
> >AccessD at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com
>
> _________________________________________________________________
> Protect your PC - get McAfee.com VirusScan Online
> http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com