I found the solution myself.
For anyone who is interested:
DoCmd.RunSQL "UPDATE tblFileNotes SET fldActivitesUndertaken = fldActivitesUndertaken & '" & Me.fldClientFirstName & ", " & Me.fldClientLastName & ": ' WHERE fldClientID = " & Me.fldClientID
I am trying to do something that seemed quite simple at first but that doesn't appear to be working. I am trying to append text in an update query.
DoCmd.RunSQL "UPDATE tblFileNotes SET fldActivitesUndertaken ='" & Me.fldClientFirstName & ", " & Me.fldClientLastName & ": " &...
I am currently trying to limit a list on a continuous form so that it is impossible to enter values that have already been entered. The list is the query value of a combo box placed on the continuous form itself. The combo box is bound to a form and I am trying to query to see if a value has...