- Joined
- Jul 12, 2011
- Messages
- 7
- Reaction score
- 0
I am trying to get column history to work in my database. I've read more posts than I care to count online with little to no luck.
I know the CODE is:
=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0))
But after I change our comments field to memo (already was) and change to append only. It still does not work. I either get a error message of “#error” or “#Name?” in the unbound text box where the results should be.
I've also tried it in one of Microsoft templates, where it works fine.
I am utterly confused. Any help would be greatly appreciated.
David92595
I know the CODE is:
=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0))
But after I change our comments field to memo (already was) and change to append only. It still does not work. I either get a error message of “#error” or “#Name?” in the unbound text box where the results should be.
I've also tried it in one of Microsoft templates, where it works fine.
I am utterly confused. Any help would be greatly appreciated.
David92595