I have seen many posts on this and have attempted the various corrections but still get an error. So I apologize in advance for repetition.
I have a Table called Invetory with a memo column for Comments. In the Design view I have the Append Only option checked to 'Yes'.
When I go to my Invetory Details Form I have tab that records Comments. On this tab one text box has the title "New Comments" with a text box below with Control Source: "Comments".
The second text box has title "Comments History" with a text box below with Control Source: =ColumnHistory("Inventory","Comments","[ID]=" & Nz([ID],0)).
I have also written it as: ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0))
When I look back to form view I continually get #Name? error.
I have looked at the sample templates and as far as I can see everything is exact. I even have deleted the whole form and made a new one.
Any suggestions?
I have a Table called Invetory with a memo column for Comments. In the Design view I have the Append Only option checked to 'Yes'.
When I go to my Invetory Details Form I have tab that records Comments. On this tab one text box has the title "New Comments" with a text box below with Control Source: "Comments".
The second text box has title "Comments History" with a text box below with Control Source: =ColumnHistory("Inventory","Comments","[ID]=" & Nz([ID],0)).
I have also written it as: ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0))
When I look back to form view I continually get #Name? error.
I have looked at the sample templates and as far as I can see everything is exact. I even have deleted the whole form and made a new one.
Any suggestions?