Recent content by deadtrees

I have a criminal justice database that is tracking cases. Cases have Evidence and Subjects. I have a subdata sheet that is a Junction table between Evidence and Subjects (both also tables) from which I can link evidence to subjects along with a conclusion. (match, no match, can't tell). The...

On a BeforeUpdate event, I've got two bits of code. One calls an Audit function and one checks to see if some criteria are met for data validation. What I'd like to do is have them work together so that if the data validation criteria is not met, it does not call the audit functions and the...

You are correct I am calling AuditData() from the BeforeUpdate event on the main form. I added acSubForm to the case, but nothing happens, does the syntax need to be more specific to actually name the controls? I read the audit trail thread on this forum where someone mentions passing the...

I found some code that I'm using as an audit trail, but it only works on the main form, it'd like to use it on the sub forms and I'm thinking that I could set the active form to whatever subform has focus and set the field that holds the audits to formname.field. Can someone help me with...