Solved: Stopping Records Being saved on form close

[BarkersIT]

Hello,

How I can stop a form automatically saving fields when it is closed?
I have written code that stops duplicate entries under normal operation but then when I close the form it saves a record in the table of the last field values and this is causing duplicate entries to be stored.

Thanks in advance

[BarkersIT]

For anyone interested add this to the before upddate event of the form

Private Sub Form_BeforeUpdate(Cancel as Integer)
Cancel = true
end sub