Message argument in a macro

[mfd777]

Easy to do in vba but trying to do in macro. I have a macro that runs a number of action queries. At the end I have a message box. I want the message box to display text and read a value in a text box from a control i.e. :
"Figures generated for" & " " & [forms]![trend_frm]![dr1_Start_Date]

 

[hennep]

Why don't you use action: "Runcode" with function name: msgbox("Figures generated for" & " " & [forms]![trend_frm]![dr1_Start_Date].text)