Delete Records

[ITbeast]

I'm trying to develop a form that can delete a record, but I want to track all deletions. What I've been trying to do is run an append query to take the selected record in the form and append it to my delete_table, then it deletes the record out of the main_table. My two problems are:
-How do I select only the current record in the form to append to the delete_table. Right now it is taking all records from the form and appending them.
-How do I accept a comment from the user. I want a popup box that asks for a reason for the delete, then include that comment in the delete_table.

 

[Crowley16]

instead of trying to do this through only the form's functions, write some code/sql to do this...

the sql statements you will need are:

--insert into deleted table
INSERT INTO tblName SELECT fldNms FROM tblNme

--add in user comment
UPDATE tblName SET fldNme = "comment" WHERE conditions

--delete the record
DELETE * FROM tblName WHERE conditions

--------------------
Procrastinate Now!

 

[randy700]

Rather than create an entirely separate table, I'd add two fields to my existing table. The first field would be something like Status and the second field would be Comments. One possible status would be Deleted. By doing it this way, you simply update the Status and Comments fields. In forms that display the other records, just add a WHERE clause that does not include the deleted records. Your "deleted" records will still be available if you ever have a need to restore them, again simply by updating the status field.


Randy

 

[ITbeast]

Great idea Randy. Never though of the simple solution to it!!