Column History Not Working

H

hmassey

Registered User.

Local time

Today, 13:57

Joined

Feb 21, 2017

Messages

12

• May 2, 2017

• #1

I'm trying to setup a comments text box with the comments history displayed in a box below it. I can't seem to figure out what I'm missing to get it to work. I know the code is
=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0))
but the only thing I get in return is #Error.

I've also made sure the Append Only property is set to Yes.

I feel like I'm missing something stupid simple. Anyone have any ideas?

 

C

CJ_London

Super Moderator

Staff member

Local time

Today, 21:57

Joined

Feb 19, 2013

Messages

17,356

• May 2, 2017

• #2

do you really have a table called recordsource? Either way it should be passed as a string so needs to be enclosed with double quotes

 

H

hmassey

Registered User.

Local time

Today, 13:57

Joined

Feb 21, 2017

Messages

12

• May 2, 2017

• #3

No, I do not have a table called RecordSouce. But everything I find on setting up this comment history uses the same line of code. None of it mentions also creating a table called RecordSource.

I have another Access file that is a Microsoft Template I modified. It came with this comment history setup on a form (which is where I go the idea to add it to my file I'm working on now) and it does not have a table called RecordSource.

 

C

CJ_London

Super Moderator

Staff member

Local time

Today, 21:57

Joined

Feb 19, 2013

Messages

17,356

• May 2, 2017

• #4

perhaps if you googled columnhistory to understand what it is, what it does and how it works, it would be a bit clearer - see this link as an example

https://msdn.microsoft.com/en-us/library/office/ff835727.aspx

you will see that 'recordsource' is the name of the table which has your 'comments' memo field (assuming that is the name of your memo field)

 

H

hmassey

Registered User.

Local time

Today, 13:57

Joined

Feb 21, 2017

Messages

12

• May 2, 2017

• #5

That would be why I was getting confused. I was copying this setup from that second file I mentioned. I was trying to make sure I modified names correctly where appropriate, but I don't find a table anywhere in that second file called "RecordSource".

Anyway.....now that I've updated the record source name to the correct table it works. Thanks a bunch.