I'm trying to add a "last updated" field to a table. So far I've got a macro that assigns the value Date() to that field for a corresponding record when run.
Now I'm trying to link it to a "save changes" command button in a DAP in its' property field "Onbeforeactivate". All I'm doing is entering the name of the macro into the field, but it throws me a script error when I click the button ('LastUpdated' is undefined). I get the feeling that the syntax is off or something (it works perfectly for a form, btw). Any ideas? Thanks a lot.
Now I'm trying to link it to a "save changes" command button in a DAP in its' property field "Onbeforeactivate". All I'm doing is entering the name of the macro into the field, but it throws me a script error when I click the button ('LastUpdated' is undefined). I get the feeling that the syntax is off or something (it works perfectly for a form, btw). Any ideas? Thanks a lot.
