Closing a form which saves the data? 1

[goodwork]

When I enter in a few fields (not all fields) and then click "close" - the table stores the data, including the blank fields!

I do not want this to happen. I want, when clicking close - lose all the information in the form. Any ideas how to do this?

Thanks so much in advance.

p.s. I know this must be somewhere in the forums - but I cannot find it....

 

[beetee]

'One way:

Private Sub Form_BeforeUpdate(Cancel As Integer)
' test all controls for null
If IsNull(Me.aaa) Or IsNull(Me.bbb) Or IsNull(Me.ccc) Then
Cancel = True
End If
End Sub

this will cause the form to never close unless all fields are entered.

alternately, you can say:

Private Sub Form_BeforeUpdate(Cancel As Integer)
If IsNull(Me.aaa) Or IsNull(Me.bbb) Or IsNull(Me.TheName) Then
Me.Undo
End If
End Sub


to clear everything

 

[goodwork]

thanks a lot

a star on the way