frmWater is bounded to tblWater. In the frmWater form, I have a "Cancel" button (btnCancel).
It is this button I want to modify to clear all currently entered data and starts a new blank page of frmWater when clicked.
The way I presently resolves the problem is by "DoCmd.Close" followed by "DoCmd.OpenForm "frmWater" which makes refreshing of my form very slow. I will like to dsicard this method and use something much better. Any suggestion will be appreciated.
Here is my current code:
Private Sub btnCancel_Click()
On Error GoTo Err_btnCancel_Click
If Me.Dirty Then
' DoCmd.Close <---- I want to remove this command and replace
it with something better
' DoCmd.OpenForm "frmWater" <--- I want to do away with this command
and replace it with something better