Hi
I am trying to replicate the column history function seen in the "issues database template" and am struggling some what. When looking at what I could online the rules seem pretty simple. Simply add a comments field to your table ensureing it is a Memo Type. Then make Append Only - Yes. Place the comments field in your form then add a blank text box to your form in design view insert into the form the following code - =ColumnHistory("RecordSource","Column","[ID]=" & Nz([ID],0)) - I have done this and it doesn't return the Comments column history it gives me a #Error. I've been at this for a while now and am really stuck can someone please help.
Please bare in mind that I am a bit of a novice with access and am self taught so far.
Thank you in advance.