G
Guest
Acc 2003 / Sql Server 200
I have a datasheet subform and I want to allow record selection and deletion
of selected records. That part works fine. What I would like to do is to
prevent deletion of one particular record (based on record values) that may
or may not be in the record(s) selected record.
This being an ADP the deletion events fire in a different order than a
standard mdb. ADP = BeforeDelConfirm, AfterDelConfirm and finally the Delete.
However in the BeforeDelConfirm I have no way to review the selected
records. Is there a way to review the selected records prior to the Delete
event? Which in the case of ADP is too late to cancel the actual deletion?
The only thing that occurs to me is to review the records after the delete
and re-add my ‘required record’ if it has been deleted. That seems silly to
me however.
I hope this makes sense and thanks for any input!
RJ
I have a datasheet subform and I want to allow record selection and deletion
of selected records. That part works fine. What I would like to do is to
prevent deletion of one particular record (based on record values) that may
or may not be in the record(s) selected record.
This being an ADP the deletion events fire in a different order than a
standard mdb. ADP = BeforeDelConfirm, AfterDelConfirm and finally the Delete.
However in the BeforeDelConfirm I have no way to review the selected
records. Is there a way to review the selected records prior to the Delete
event? Which in the case of ADP is too late to cancel the actual deletion?
The only thing that occurs to me is to review the records after the delete
and re-add my ‘required record’ if it has been deleted. That seems silly to
me however.
I hope this makes sense and thanks for any input!
RJ