OOPS!! I didn't mean to click Close Button

[mikelt]

If a user clicks the Close Button of a form you can put code into the On Close event to check if specific data fields have been entered but how do you then stop the form from closing and take the user back to the partially completed form?

Any help would be appreciated.

Thanks
mikelt

 

[tunsarod]

Study the help on the CancelEvent method. Also the Undo method might be useful if you want to set the form back to how it before a record was edited.

As an example you use code like this in the OnClose event:

If IsNull([Important_field]) then
CancelEvent
end if

Also you should consider setting the Validation property for reuired fields to force valid entry before a record can be saved.

Rod

 

[dakota81]

Another route, you can disable that close button in the upper right hand corner, and have a command button that exits out of the form (after verification of course).