Add/Change and Delete (1 Viewer)

sloaner14

Registered User.
Local time
Today, 06:11
Joined
Apr 25, 2002
Messages
32
I am tired of trying to figure this out, so I humbly ask for assistance. This may be so simple. I have a procedure that will append a record with New, Edit, or Delete depending on the event. I have the BeforeUpdate event (if me.newrecord "New" Else "Edit") working great, and the Delete event for "Delete" works. The problem is with the delete, it wants to trigger both BeforeUpdate and Delete event. Am I doing this wrong or is there a way to determine if the record is being deleted in the BeforeUpdate and then apply "Delete"? I can't seem to find the answer to this problem on previous threads.

I have always found every answer here, thanks. Great site!!!
 

Guus2005

AWF VIP
Local time
Today, 07:11
Joined
Jun 26, 2007
Messages
2,645
Add a boolean which you have to set when clicking the Delete button. In the before update event, test is to be false (or true) and continue.
 

Users who are viewing this thread

Top Bottom