Access UpdateField

[paw]

Hello,

I am creating a database that will be used by approximately 6 users. They will need to logon. They also want a field they are calling an update field. Whenever a record is edited they want the person who did the editing's name to appear in that field along with the date.

Any code or macro ideas would be grately appreciated.

Thanks

paw

 

[BlackKnight]

Hi,

When a user edits a field(s) of a record on a form...you could call a function EditLog(currentuser(), Now()) in the form's AfterUpdate event. This way you'll know the record has been edited and you can record the transaction in your table fromthe function.

Have a good one!
BK