Recent content by ddt1972

Thanks for the response, sorry for the late reply. I have been under the weather, will try that and post back.

I have a database where the management screens jobs for the techs to do, and they print them out one record at a time to hand them out. I am trying to figure out how to have the record added to the working table for the techs to be able to update status once the manager prints it. The techs do...

Here is a copy of the form in question, and the module being called up for the audit trail.

I have an option group that the user clicks on a radio button to change the status of a job, ie active, awaiting parts, awaiting other....etc. I also have an audit trail using this code: Option Compare Database Const cDQ As String = """" Sub AuditTrail(frm As Form, recordid As Control)...

I am trying to do something very similar, how did it work out for you Spirit?

All, I have implemented the audit trail, and it works great, except for one of my forms which uses checkboxes. The audit trail does not record changes to yes/no boxes. Is there a way to make it recognize and record changes to these?