how can i document who last changed a record and at what time 1

[lewie]

I need to add a last user and last time changed to my db.
I think when they update a record i can just let [lastdate] = date but how do i document the current user.
Thanks
Lewie

 

[FancyPrairie]

First you need to add a couple of fields to your table and them add them to your form (they can be invisible if you like)

Field name in table Control name on form
strModifiedBy (test) txtstrModifiedBy
dtmModifed (Date) txtdtmModified

Then in the BeforeUpdate event of the form, do this

txtstrModifiedBy = CurrentUser
txtdtmModified = Now

 

[lewie]

Thanks.
What does beforeupdate do.
If i want to know the last person to change it shouldn't i use on dirty.
Lewie

 

[MichaelRed]

for a more robust soloution see faq181-291. be aware that all soloutions to this require that ALL changes be accomplished through BOUND FORMS, and the implementation of Ms. A. Secutity.




MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[lewie]

Thanks alot
Lewie