Question

Overwrite previous record with VBA code

VBA, Excel macros, Microsoft Excel, Visual Basic for Applications

I am doing a training exercise. All works OK as per the notes with a new record being added when the OK button is clicked.

Now I want a script that overwrites the previous record and not to add a new record / row on pressing OK. Pls help with code

Hello Battler,
you can query your last record (SELECET MAX(ID) as LASTID FROM TABLE) and then perform a DELETE FROM TABLE WHERE ID=LASTID-1.

Bye

Or maybe an UPDATE SQL sentence:
UPDATE theTable SET theName = "Battler Guy" WHERE id = (SELECT MAX(ID) ...)