VBA Msg Box to Text Box on Report

[yakdogs]

I have a report that has a parameter written in VBA. The powers that be would like this parameter listed on the report. This is part of the code.

strBegDate = InputBox("Beginning Date&quot
strEndDate = InputBox("Ending Date&quot


I would normally build it in a query but the back end is SQL, and I am using a VIEW.

I would normally use a text box set as this:
="For the dates of " & [Beginning Date] & " to " & [Ending Date]

But this does not seem to be working. How do I get it populate a text box?

Any help is greatly appreciated.

 

[dyarwood]

In the VBA can you not do the following

TextBox1.Text = "For the dates of " & strBegDate & " to " & strEndDate


Could this work for you where your textbox is called TextBox1