Assigning Function Value to Report Field

[vr]

I am trying to assign a value returned from a function to an unbound field on a report via VBA.

This code:

Me.Text78 = Report10d(SumDateFiled)

Returns:

"Can't assign value to this object."

Obviously, I have not done this before.

Any help would be greatly appreciated.

 

[JoeMiller]

Rather than assign it in vba, make the controlsource of the unbound field this:

= Report10d(SumDateFiled)

HTH Joe Miller
joe.miller@flotech.net