How to copy field information from deleted records selected in datasheet view

[Ampridge]

I am trying to keep a log of records that I have deleted. I am trying to find a way to create an array of "CustomerID "(autonumber field) that stores information of the records selected when I hit the delete button. To further complicate the process the CustomerID number is part of the record source but is not on the form. Any suggestions would be appreciated.

[TheSmileyCoder]

This doesn't exactly answer your question but I thought I would just say how I handle deletions. I simply have a field in my database bDeleted, which defaults to false. Whenever I "delete" a record, I simply switch the boolean to True, and of course my queries all run filtering out the "deleted" records. This gives me the advantage of never really deleting the records, should I ever need to retrieve them (which happens).

[Ampridge]

Thanks for the response. I may use that for some tables. But I import a lot of data into the pricing records to merge then I delete it when I am done. So this could leave a lot of extra data which is probably not a good idea.

[Ampridge]

This makes sense to me when deleting one record but how do you handle multiple records being deleted at the same time?

[TheSmileyCoder]

You simply run an update query instead of a delete query. Another option is to transfer the records out of the main table and into a table of deleted records.

If you want progress on your original question I will need more information on exactly what information you wish to store and where.

[Ampridge]

I am not running a delete query. I am selecting specific records in the datasheet view to delete and then clicking the delete record button on the toolbar. I do not want to transfer records in a table of deleted records as I have one table that logs all of the table ID numbers but it is not set to hold other field information. I guess my main question is to find a way to create an array of field ID values based on the records selected in a datasheet view when clicking the delete record button.

[TheSmileyCoder]

If your doing your deletion from a form, in datasheet view mode, you can tie code to the deletion event, in which you add the ID of the deleted record to "somewhere". I dont think you can store it as an array, but you could store it as a comma-seperated string in a memo field, or as suggested earlier, have the delete event, make a copy of the record to a secondary file, and even do such things as register who deleted it and when.

[Ampridge]

Yes, I agree I can tie it to the delete event (that is what I have done so far) which would be fine if I was only deleting one record but the issue I have is deleting multiple records at the same time and logging this information

[TheSmileyCoder]

I see. As you can see from my posts I dont actually use hard deletion much. I just assumed that if you deleted multiple records, the delete event would run for each individual record.