Hi,
I am new to Access and am trying to self teach as I write a new database for work. I want a comments history on a form and with a little investigation found that a text box on the form with the following in the expression builder should do the trick -
=ColumnHistory("SPP Records","Progress Entry","[ID]=" & Nz([ID],0))
SPP Records is the main table and Progress Entry is the memo field / column (with append only applied) where the comments are entered.
However, all I get back is #Name?
If I revise the code to -
=ColumnHistory("SPP Records","Progress Entry","[ID]=10")
Then the comments history is returned, but this will obviously only work for the record with ID=10.
What am I doing wrong?
Thanks!