Column History

[linles01]

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.

[linles01]

Solved it by accident.
Turns out there were remnants of Access 2010 left on my machine when it was previously installed so I did a Mr Fix It clean up ...................... Problem Solved