Insert calculated date into message

[kgranneman]

I have a date field that caculates on click of a command button in a form. I like to use that calculated date in a message set in the body of an appointment reminder.

I want the message to read:
"Connection Date [insert connectdate from calculated field]"
Me![frmAppoints]![ApptNotes] = "Connection Date" + "" + [ConnectDate]

I've tried various combinations of double quotes and flanking the calculated field in # signs. The result is either nothing of it returns the words [ConnectDate] rather than entering the actual calculated date.

Can someone guide me on the proper way to call a field like this to return the value calculated rather and the control name?

Thanks.

 

[vbaInet]

You concatenate with the ampersand (&) character.