Warning Message

[RobNauticus]

Hello,

I want to give my users a warning when moving to the next record if certain fields or procedures are not entered properly.

Where can I postpone the record change on a bound form to allow an OK/Cancel Message box to popup and ask the user to continue or remain at that record?

Much Thanks,
Rob

 

[Apollo6]

Why not trap the bad insert in the After_Update event on the field(s) as they fill in the form? For example, if the field cannot be NULL, check the value After_Update, if it IS NULL, popup a message box and return them back to the field.

 

[PHV]

A common way is to use the BeforeUpdate event procedure of the form, playing with the Cancel argument and the SetFocus method when the validation rules are not meet.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886