ColumnHistory in a form

[JeRz]

Hi everyone,

I am attempting to have a text box populate with historical changes on one of my forms.



The field name is IssueDetail and is set as Memo. It is in the tblIssues table. I have set the Append property on the IssueDetail field to True. I also added a History text box to the form with the ControlSource set as:

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

After doing all of this, I am receiving a #Error in the History text box. I have been trying most of the day to get this to work. Can anyone offer any suggestions?

Thanks!

[aytee111]

This is not generally the accepted way of doing this. You would rather have a table containing the key to the item and the old value, also date-changed and user-changed if you wish. Then display this as a subform or listbox.

[Missinglinq]

First off, I suspect that [RecordSource]

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

is not the actual name of your Record Source...isn't it tblIssues?

Also, per Access Help, a Memo field's AppendOnly property must be set to True in order for Access to store the change history for the field.

Linq ;0)>