columnhistory

[Jazzmar]

Where do I find out how to do a columnhistory. I've created a table with
fields ID, and Comments, on the Comments field I have the Append Only set to
Yes. On my form I have both fields ID, Comments and a textbox called
CommentHistory. My control source code is
=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0)) for the
CommentHistory. I get a error.

 

[Dirk Goldgar]

Where do I find out how to do a columnhistory. I've created a table with
fields ID, and Comments, on the Comments field I have the Append Only set
to
Yes. On my form I have both fields ID, Comments and a textbox called
CommentHistory. My control source code is
=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0)) for the
CommentHistory. I get a error.

What do you mean by "columnhistory"? Access has no built-in function of
that name. What is it that you would want to see in your CommentHistory
text box?

 

[Douglas J. Steele]

Where do I find out how to do a columnhistory. I've created a table with
fields ID, and Comments, on the Comments field I have the Append Only set
to
Yes. On my form I have both fields ID, Comments and a textbox called
CommentHistory. My control source code is
=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0)) for the
CommentHistory. I get a error.

What do you mean by "columnhistory"? Access has no built-in function of
that name. What is it that you would want to see in your CommentHistory
text box?

Actually, it was added in Access 2007:
http://msdn.microsoft.com/en-us/library/bb242869.aspx

That having been said, I have no experience working with the new method, so
I can't offer Jazzmar any suggestions.

 

[Dirk Goldgar]

Actually, it was added in Access 2007:
http://msdn.microsoft.com/en-us/library/bb242869.aspx

Really? Blast, I hate giving incorrect answers! Now I must research it so
I can give a proper answer.

 

[Dirk Goldgar]

Where do I find out how to do a columnhistory. I've created a table with
fields ID, and Comments, on the Comments field I have the Append Only set
to
Yes. On my form I have both fields ID, Comments and a textbox called
CommentHistory. My control source code is
=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0)) for the
CommentHistory. I get a error.

What do you mean by "columnhistory"? Access has no built-in function of
that name. What is it that you would want to see in your CommentHistory
text box?

Now that Doug has set me straight, I've done some quick testing in Access
2007. The expression you wrote is working on my test form. What error do
you get?