User Actions

[CementCarver]

I'm using Martin Green's vba code to track changes/edit to an audit table. In his code sample, there's a select case section where the code attempts to track what type of user action is taking place.



Select Case UserAction
Case "EDIT"
rest of code here
Case "Else"
rest of code here

The program gets to the Case "EDIT" line and just skips over it and ends up at the Case "Else" statement, but I was actually editing records during that time.

How many actions are there? How does one know what sort of action is going on at that time?

Can anyone offer any suggestions?

CementCarver

[CementCarver]

The line Case "EDIT" should be without quotes.

CC

[June7]

No, the Case Else should be without quotes.