Disable Add Row

[SharonInGa]

My current error code resides in an ADD button and in Form Error and
validates missing required fields when the user tabs or presses the ADD
button, however, the user can still jump from the current row to a new row
without adding the required fields.

Required Required Required Optional
Date



Is there a way to disable Access from adding another row until the required
fields are added. The user needs to be able to edit the current records as
well.

 

[Troy]

Set the ValidationRule of the control to not allow nulls or blanks.

Len([txtTestField])>0

OR

Set the underlying Table field property Required = True.

HTH

--
Troy

Troy Munford
Development Operations Manager
FMS, Inc.
www.fmsinc.com



My current error code resides in an ADD button and in Form Error and
validates missing required fields when the user tabs or presses the ADD
button, however, the user can still jump from the current row to a new row
without adding the required fields.

Required Required Required Optional
Date



Is there a way to disable Access from adding another row until the required
fields are added. The user needs to be able to edit the current records as
well.