[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