Comments History

[stu]

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!

[June7]

Everything I read indicates cannot use a variable in ColumnHistory expression, only a literal string.

[stu]

OK thanks. Any idea how I put a unique literal string in each form for each record?

[June7]

Hmmm, another search indicates a variable is allowed but must return only one record or will error. View this thread
http://www.utteraccess.com/forum/col...d#entry1938724