Forms4.5 HELP !!!

From: Andrew M. Balshem <am_balshem_at_fccc.edu>
Date: 1997/11/04
Message-ID: <345f7853.111027789_at_news.services.fccc.edu>#1/1


[Quoted] [Quoted] We've a very simple forms 4.5 application (10 fields). ID and SPECIES fields cannot be null. I've a trigger on both fields to make certain that neither are null.. When I enter the form my first enterable field is ID and the cursor is placed there. If I click anywhere prior to entering the ID I receive an error (that I must enter ID) as I should. However, after I've entered ID if I use my mouse to skip over the SPECIES field I don't get a similar error unless I've first entered the SPECIES field. I've tried using each of the WHEN-MOUSE... triggers to no avail. I do have a pre-insert/update trigger that checks that both fields are not null & these do prevent commiting bad data to the database. I would, however, like to write a trigger to immediately inform the user that SPECIES cannot be null whenever they've used a mouse to skip over the field. Any solution? Received on Tue Nov 04 1997 - 00:00:00 CET

Original text of this message