I have a report with a texBox which opens via a form. Changing the value of the TextBox from the form by means of VBA fails. The information in the TextBox is very important to the user, because tells him the time interval of the report's filter. The solution is higly needed. Please help !!!

Hi,

Create a module called Public Variables, then add this to the module:

Public pMyValue As String

Then on the button that opens the form, capture the values in this public variable (I assume you are checking for this date range first):

pMyValue = Me.StartDate & " to " & Me.EndDate

Then on the On Format event of the section that has the text box, add this:

If pMyValue <> "" Then
Me.TextBox = pMyValue
End If

I hope that helps.

__________________
mmcdonal

Look it up at: http://wrox.books24x7.com