If I get a chance, I'll take another look this weekend. Otherwise, it could be hard to find the problem if it doesn't happen all the time and without a pattern.Any suggestions pls?
or is there another alternative to log the delete action, id and code in the table or by a macro??
akika,
I'm not sure if you are basing your code on the Martin Green (fontstuff) example, but you may find this thread -especially the interaction with PSSMargaret - useful.
As for alternative audit approach, you may find this useful.
Good luck.
Private Sub Form_Open(Cancel As Integer)
show = True 'for debugging jdraw may 28 19
Dim ctl As Control
On Error Resume Next
For Each ctl In Me.Controls
Debug.Print ctl.Name & " >" & ctl.Value & "<"
Next
End Sub
[COLOR="Blue"]Text214 ><
Combo224 ><
ID >908<
Form Code >1234<
Form Name >AKIKA<
Process ><
User BU ><
Author ><
[/COLOR]
ID EmplCode EmplName Comments HomePhone Address
908 1234 AKIKA
909 A 2345 test
916 987 sam
921 Polly Dactyl "Test of audit, ""audit""" 35 234 235 12 Lakeside Road
923 abear Kodiak Bear jed test2 123Goldilox 1 Dark Forrest Path
924 Bob Robertsville Hi I'm Bob
ChangeID DateTime UserID FormName FieldName OldValue NewValue Action RecordID EmplCode
70 28-May-19 4:46:14 PM customer Comments jed test2 jed test2 editing 923 Kodiak Bear EDIT 923 abear
[COLOR="Blue"]FormName -- ControlName{controlType}
customer | Text214(TextBox)
customer | Label215(Label)
customer | Command222(CommandButton)
customer | Command429(CommandButton)
customer | Combo224(TextBox)
customer | Label225(Label)
customer | Command210(CommandButton)
customer | ID(TextBox)
customer | ID_Label(Label)
customer | Form Code(TextBox)
customer | Form Code_Label(Label)
customer | Form Name(TextBox)
customer | Form Name_Label(Label)
customer | Process(TextBox)
customer | Process_Label(Label)
customer | User BU(TextBox)
customer | User BU_Label(Label)
customer | Command168(CommandButton)
customer | Author(TextBox)
customer | Author_Label(Label)
customer | Command441(CommandButton)
[/COLOR]