Delete query - current record on form

[Will_Harris_ZA]

Hi there

Please help!

I would like to place a command button called "Clear" on my form to delete
the current active record and enable the entry of fresh info (with a new,
unique autonumber).

(This old info is being seperately appended)

At present, my delete query will delete the whole table or data grouping (it
is categorised into commercial properties).

Thank you
Will

 

[Ofer Cohen]

First, don't forget to create a back up for your data.

Now, if the form is bound to that table, you can create a button and use the
wizard to create a delete button that delete the current record

Something like:

' Delete the current record
Docmd.RunCommand acCmdDeleteRecord
' Move to a new record
Docmd.GoToRecord , , acNewRec

 

[Will_Harris_ZA]

Hi Ofer

Thank you for your response. I first need to get some feedback on the
(preceding) append part of the process, before I can try implement your
suggestion.

I will keep you posted on my progress.

Thanks
Will