I have a combo box that has various statements that when selected copy on to the end of the value in a memo field. What I want to be able to do is to reference a different field on a form in one of these statements. Eg: a statement in the combo box says something like "<<FORENAME>> has worked very hard this year." when this statement is selected the database should look to see what value is currently being shown in the Forename field and the value copied to the memo field should read "Bob has worked...". The 'FORENAME' reference does not always come at the start or the end of the statement.
Is this possible?
I tried using the replace function on the after update option of the combo box
but kept getting 'Compile Error: Expected: ='