[AccessD] ValidationRule+

Mark,

I have single-record forms where I edit all the fields in the OnClose
event.  If all the edits are not passed, they cannot close the form and
save the data.

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: Wednesday 2003 Jul 16 08:01
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] ValidationRule+

Ok...I'll side step...
ValidationRules on Table=enforces when saves or when main form loses 
focus...not an option.
ValidationRules on Form=enforces when changing field...not on save.

Is there a way to force the Form ValidationRules via code?  Maybe loop 
through all controls and validate?  The problem is if I have a field
with 
ValidationRules...and the user does not edit that field...the form 
validationRules are not enforced?

Any ideas?

Thanks,

Mark A. Matte


>From: "Borge Steen Hansen" <pcs at azizaz.com>
>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: Wed, 16 Jul 2003 10:28:50 +1000
>
>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
>