Newbie-How to create a History field?

[bdkennedy1]

Sorry I'm new. I need to create a History field. I need to populate this field with the date, time, the name of the person logged in and what fields they changed. Can someone point me in the right direction? Thanks!

[stanley]

BDKennedy1:

Create a field which is a calculation, unstored, text, and set it to:

Get ( CurrentHostTimeStamp ) & " " & Get ( UserName )

-Stanley

[Ender]

Check out the Change Log 2 demo on databasepros.com for a technique that logs the fields being changed with the value.