adding new records to a table through a form

[Dylan Snyder]

I'm new to VBA (actually know nothing about it) I have a subform that is based off of an updateable query that updates the Customs Master and Item Master tables. So far so good. I'm trying to make an audit table that gets written to upon change of the subform.

I have unbound fields on the subform that I've set to default to the fields on the subform. Upon change of one of the bound fields, I want the unbound fields to be written to a new table entitled Customs Master Audit and record the day's date. Any ideas? also, does anyone know of a quick VBA tutorial on the web that tells in plain english how to define objects...etc.? Any help would be much appreciated.

 

[GaelicFatboy]

Regarding your tutorial, I bought myself a few books one of which is this:

Title: Access 2003, Inside Out
By: Mircosoft press
ISBN-13: 978-0-7356-1513-7
ISBN-10: 0-7356-1513-6

It's a chucky book but covers a good amount of material, and is the one I refer to the most along with this website.

Best of luck on the learning curve.

D

 

[The_Doc_Man]

Search this forum (it has a decent if uninspired SEARCH function) for

Audit Trail

Auditing

Change History

 

[rolaaus]

I did something very similar to this with my first Access database. it was an auditing application for a manufacturing company that tracked when a "lot" was moved from one department to another - they wanted to see how long each type of product took to push through each department.

There is a property of a record that tells you wether or not there were changes, it's .Dirty

Also, there is a property for calling the "old value" of a control once it has been changed - oddly enough they call it .Oldvalue

If you still are in need of help, I can post you what I should have done the first time I did it - but admittedly, I was learning, so I don't think I did it right way back then.

 

[Dylan Snyder]

Great thanks,
If you could paste it here, so I could see what you were doing, that would would be greatly appreciated. Thanks,