Re: Please HELP - Forms 4.5

From: sander smit <sander.smit_at_cmg.nl>
Date: 1997/11/13
Message-ID: <64f6pp$lip_at_hdxl16.telecom.ptt.nl>#1/1


[Quoted] Why not make the fields mandatory (using the field property)?

[Quoted] am_balshem_at_fccc.edu (Andrew M. Balshem) writes: > 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 Thu Nov 13 1997 - 00:00:00 CET

Original text of this message