display a message when removing and adding entries

[usheikh]

Is there a way to display a message everytime a user has removed and/or adds an entry to a form? I'm using Access 97

 

[lupins46]

If you delete a record through a form you are asked to confirm the deletion. Isn't that enough?

If you just want to Report the addition then use the AfterInsert event procedure and just put:
msgbox "You have added a new record".

If you want to warn the user BEFORE the record is about to be saved, then you can ask a question in the Form_beforeupdate event procedure.


if not me.newrecord then exit sub
if msgbox ("Confirm add new record?",vbyesno) =vbyes then
' do nothing
else
cancel = true 'stop the save
me.undo ' to undo the new record, if required
end if

 

[usheikh]

Hi,

Thanks. It works for adding or changing a record. But if I try and use AfterDelConfirm or AfterUpdate events then it doesnt work for deleting the record. Could it be because there is a row selector next to the record on the form because you can usually select a number of rows using the selector and hit the delete key to remove them. I want a Message displayed after a record is deleted using the record selector.