macro that creates date modified field

[Shawna]

I need to have my database show when a record is modified. I created a macro
but keep getting a 2950 error. I used the 'Store the date and time when a
record is modified' help topic but can't get it to work. I get this error
message "Microsoft Access can't find the name 'Date Modified' you entered in
the expression." I can't figure out what I am doing wrong. I am a new user
so answers need to be simplified. Please help!

 

[Steve Schapel]

Shawna,

Can you have a look at the design view of the macro, and let us know the
details (Actions and Argument) please?

Also, when is the macro supposed to be executed?

 

[bhicks11 via AccessMonster.com]

Hi Shawna,

In a form you can add a line to the BeforeUpdate event like this:

Me.datecontrol = now()

and if you don't want the time, do this:

Me.datecontrol = format(now(),"mmddyyyy")

Bonnie
http://www-dataplus-svc.com

 

[Shawna]

I deleted everything I did and started over. The macro works now. I think
the problem was in capitalizing the words in the table but not the macro.
Anyways...thanks for your help.

 

[bhicks11 via AccessMonster.com]

Good going - glad you found your solutions!

I deleted everything I did and started over. The macro works now. I think
the problem was in capitalizing the words in the table but not the macro.
Anyways...thanks for your help.

Hi Shawna,

[quoted text clipped - 15 lines]