I'm trying to build a report and trying to tie the following code to a txtbox (comments)

=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0))


This is coming from one query. When I add another table to the query, I get an #Error when displaying the report. Why?

I have 2 tables - Customer & Opportunities. The above code is from the Opportunities. When I add both tables to the report, it links CustomerID to Opportunities ID because opportunities is the child.

anyone know a way around this? Basically I have a comments textbox and each note added is time stamped and recorded. I want all the comments to print out on the report w/ the time stamp.