Asp updating access check box

After all, you don't really need to maintain data types for auditing purposes. Print statement allows you to see the evaluated INSERT INTO statement in the Immediate window.

If you experience problems, this is a useful debugging tool.

If the values are the same, there's no change to track, and VBA skips to the next control.Our procedure contains a minimum of error handling.You'll want to customize the procedure to meet your needs.In a production form, users wouldn't even see this value.) Pressing [Tab] moves to the next record, which executes the form's Before Update event.That event procedure passes the two objects to Audit Trail(): the form and the data (as a control object) that uniquely identifies the current record. Each statement cycles through the form's Controls collection.

Leave a Reply