What is the form event ?

[cheer]

I have a form with a query embedded into the form. Whenever there is change to the field to data via the form, i need to record the history.

My question is at what form's event or etc event I need to write the VBA code ?

 

[stopher]

I would suggest the After Update event for the form.

hth
Chris

 

[missinglinq]

Allen Browne has a tutorial on creating an audit log here

http://allenbrowne.com/AppAudit.html

I have to tell you, though, that such an undertaking is not for the faint of heart!

Good luck!

Linq ;0)>