Recent content by Andrew Johnson

I can't post my database because of ownership issues. However I can post my updated code: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim C As Control For Each C In Controls Select Case C.ControlType Case acTextBox, acComboBox, acCheckBox Dim...

An excellent point about multi-records. I've been testing with only one but you are 100% right. I've fixed this by moving my form_load code to form_current. The problem with the same query executing persists however. I've added that debug.print line to my code but can't seem to figure out...

Hi, I've actually come up with a table that covers all things about the audit needed and have produced the code to do so (I actually used a lot of code from that MS Support link you provided) -- my problem is some kind of weird abnormality... I posted this question on stack overflow (can't post...

Well I am almost done finalizing the auditing portion of an application. The way I am doing it is looping through all text fields, drop down boxes and checkboxes and storing their values in the form_load event. Then I am doing the same thing in the form_afterUpdate event and comparing the two...