marcel.vreuls at achmea.nl
marcel.vreuls at achmea.nl
Tue May 27 08:13:35 CDT 2003
Hi Charles, The problem is the following. When putting the validation code in the beforeupdate event it is being validated. The problem is that on field level the required propery is TRUE and I get also that message if users do not fill in that field. And it is one ugly message. So I have to validate if there is a value in that field before going to another field or form. The problem is that I do not know when they are going to this field, the user can start somewhere else. My guess is that there are two solutions. One is filling in a default value in this field or removing the required property. Both solutions are not the most beautifull but they seem to work. Any suggestions? Thanks, Marcel Vreuls "Wortz, Charles" <CWortz at tea.state.tx.us>@databaseadvisors.com op 27-05-2003 14:20:28 Antwoord aub aan accessd at databaseadvisors.com Verzonden door: accessd-bounces at databaseadvisors.com Aan: <accessd at databaseadvisors.com> cc: Onderwerp: RE: [AccessD] Simple Event question, I guess Marcel, What do you want to validate? If it is a datum on the parentform, why not validate it in its own BeforeUpdate event? If it is a relationship between several data on the parentform, why not validate it in the form's BeforeUpdate event? If it is data on a subform, then use the corresponding events of the subform. If none of the above cover your situation, please explain in more detail. 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: marcel.vreuls at achmea.nl [mailto:marcel.vreuls at achmea.nl] Sent: Tuesday 2003 May 27 03:11 To: accessd at databaseadvisors.com Subject: [AccessD] Simple Event question, I guess Dear group, I am looking for the following. I have a ParentForm and within that parentform I have two subforms. Now I want to do some validating when I user leaves the parentform and enters one of the subforms. Any idea, suggestion what event that is? or how I can solve that. Greetz Marcel _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ***************************************************************** Dit bericht is bij binnenkomst gecontroleerd op de aanwezigheid van virussen. Er zijn geen (bekende) virussen gevonden. Active ***************************************************************** ********************* DISCLAIMER ********************* De informatie in dit e-mail bericht is uitsluitend bestemd voor de geadresseerde. Verstrekking aan en gebruik door anderen is niet toegestaan. Door de electronische verzending van het bericht kunnen er geen rechten worden ontleend aan de informatie. ************************************************************