I am new. I have first Question

[Magnus1982]

Hi All,



I am from Poland. I just started learn Access . I have first block... sombody will help?

1. I wanna to write down in some record for example name but in another record i wanna have automatic generated date of write this name. If i will change this name in the future the date should change to day when i made modyfication. I already made tabel and from and field where should generate the modification date but i don't know formula or makro which i have to use to do that.Tnx for any help

[June7]

If you care about keeping history of the name changes, sounds like an audit log. Review http://allenbrowne.com/AppAudit.html

If you don't care about history, then just have date field in the same table and code to set the date when the name changes. VBA code in the control's AfterUpdate event, like:

If Me.[controlname].OldValue <> Me.[controlname] Then Me.[date fieldname] = Now()

[Magnus1982]

Yea is working. But only after update this filed . It should alsow put date when you wrtiting first time.

[Homegrownandy]

the 'default value' in table design needs to be "=date ()". that way by default. any new record will show that days date.

I'm sure Junes suggestion is a more elegant solution to update. But you can have a look how update query's work too.

[June7]

If you want full data and time, use Now().