thanks Piet, yes the before update checks for null values and cancels the
update if nulls found. The update is canceled which stops any incomplete
records from being saved in the table, however the app still closes, the
record is not saved, and from a user's point of view, data that has been
entered has been lost.
How can I stop the app from closing and in the process closing the form by
canceling the update if required data is not entered? I don't wish to disable
that main app X at top RHS. I still want users to be able to quit from
clicking that main app X.
> How about checking for Required and stopping the close if the values
> there are null?