RecordSource History

[jaad]

I've picked up this neat little line on an inventory database online

=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0))

The effect of that is whenever you enter a comment, this line saves it in an unbound field(as far as I can tell) and every time you write something new it gives you a data stamp on it like this

[Version:  08/02/2010 3:51:48 PM ] This Fixture is easily installed and would be a great fixture to replace in all suites loaded with a fluorescent bulb.
[Version:  

12/02/2010 4:57:53 PM ] Quality assurance review showed the unit to perform well, is easily cleaned and illuminate well

I'm trying to copy this line and looked at all the setting everywhere to make sure the new location where I want to use this have the same setting but I keep on getting an error message.

Do anyone of you know how to reproduce this command line so it works?

[jaad]

OK, I found the problem. The Append Only Setting must be set to yes. works fine now thanks