Concatenating fields

[Sol]

Hello!

I have 3 combobox fields and a memo field on a form. In the memo field, I need to concatenate Fields 1-3 and allow for the user to modify and add to what appears in the memo field.

I set the control source of the memo field to
=[Bank]+" "+[TitleCompany]+" "+[Attorneys]

but I am unable to edit it? Any ideas?

Thanks !!!

 

[R. Hicks]

Do not use the control source of your memo.
You will need to use the After Update events of all 3 of the references. The same code goes in all 3.

If IsNull(Me![Bank]) Or IsNull(Me![TitleCompany]) Or IsNull(Me![Attorneys]) Then
Exit Sub
Else
Me![yourMemo] = Me![Bank] & " " & Me![TitleCompany] & " " & Me![Attorneys]
End If

Remember this need to go in all 3, "Bank","TitleCompany", and "Attorneys"

Also rename "yourMemo" to the actual name of your memo.

HTH
RDH

 

[Sol]

Thank you this worked!! :0)