>Has anyone come up with a good method that will
>allow a user to cancel an operation while they are
>on a field that requires entry.
>
>They have requested to add a new record.
>The user is then presented to a screen with X number
>of fields, some of which are required and in their
>VALID code states IF EMPTY(fieldname) THEN 'Field must
>be filled' ENDIF
>
>but what if the user presses the CANCEL button, how do I
>know that they have touched the CANCEL button so
>as to let them out of the required field and let the CANCEL
>valid be fired off.
>
>Any suggestion please.
>
>Bret

Try to use LostFocus() instead of Valid(). I have no time to test it but I think you can make a combination of LostFocus and Valid.