Error Handling in Access 97
Posted on 2003-02-23
I am back again. Thanks for all the tips and solutions I get from the experts.
Well, I have encounter some problems yet again.(Beginner that's why)
How do I ignore all the inputs in a form and Close the form without the Error massage pop up before the form closes ?
I have a field which is input masked as date.
When I keyed in 56/56/56(Invalid) and I pressed the close button(X) at the top right hand corner of the form, I get an error message telling me it's an invalid entry, then it prompt me again to select whether to exit and not save the records or to cancel to go back again.The massage is "You can't save this record at this time"
By the way, I didn't even try to save the records as all the actions are done only when the save button is clicked, meaning all the saving code is at the On Click Event.
I used the OnClose and OnError property of the Form to handle the Error.
"On Error Resume Next"
This doesn't work for me and the two massage kept popping up.