deleting last record 2

[kkson]

On my form I can delete a record with a button. If I delete the last record of the table (I know this because I just added it to the table) the fields all go blank and when I try to go to another record I get the index or primary key can't be blank.

Thanks

 

[WillyG]

Ignorance is bliss! I used it at the end of the same sub that, on clicking a command button, causes the current record to be inserted in a different table and deleted from the active table.


WillyG