ColumnHistory with multiple columnnames

[Nadine67]

Hello and thank you in advance for any attention this post may recieve.

So I have a text box where 'columnHistory' is working. I would like to append the comments of more than one text box (columnname) in onw timestamp.

currently my control source is

=ColumnHistory("tblImprovementIdeas","Comments","[ImprovementID]=" & Nz([ImprovementID],0))



I would like to add "Status" and "Review Date" to the coulumn name so that the appended timestamped history recorded is comments, status, and review date data

Is this possible?

thank you

[June7]

Not really understanding question.

ColumnHistory is a property setting for a Memo type field. The expression you show is just to display the history. If you want to maintain history of other types of fields, that would probably require audit log. Review: http://allenbrowne.com/AppAudit.html

[CJ_London]

Is this possible?

Simply, No. The commenthistory property is intended to display the history of changes to the comment and when those changes were made. It is not intended as a record of comments (e.g. logging calls with a client) or a basis for further actions or who entered the comment. I would follow June7's lead

[June7]

Or maybe instead of continually adding text to the memo field, each should be a new record in a related table.

[Nadine67]

Thank you June and Ajax

An audit log is what I am after, so the link to Allen Browne's tutorial is a great help.

Thank you and have a great day!

Nadine