Required Updated to Yes not relfected on form even on control box

B

blueboy1894

Hi

I have a form where certain fields that weren't required fields before now
have to be mandatory.

I have changed the Required property to yes in the bound table but when I
enter a new record in the form and exit the form, I don't get the error
message.

I know if I'm leaving the form with code, then I need to trap the error but
it exits silently even from the "x" on the form's control box.

Any idea what's wrong here? Is there a way to get the form to pick up the
required property (I have even tried re-adding one of the affected fields to
no avail).
 
B

blueboy1894

This only seems to happen for new records. If you add a record, set one of
the required fields to have a value, and then attempt to set the field to a
null string then the error fires.

Am I missing something basic here about why the New records don't carry the
failure error at the save point (i.e. when the record is first saved at the
point the form is closed)?
 
Top