-----Original Message-----
Add a field to your table, date/time type, named
LastUpdated. Set its defautl property to "=Now()"
Now, in your form, add the field to the form. Then, click
on properties, events, and for the AfterUpdate select
[Event Procedure]. Click the builder button (3 dots), and
you're in the VBA Editor.
Add the line:
Me.LastUpdated=Now()
Chris Nebinger
-----Original Message-----
I am trying to create a date stamp which is added to a
table(s) every time a record is modified. I tried to use
a macro(which I do not like to use)that is like article
209637 on the MS knowledge base. The error I get is:
You tried to run a VB procedure to set a property or
method for an object. However the component doesn't make
the method available for automation.
I don't really understand this error. Is there a way to
add the date stamp?
Thanks,
Deeann
