DCount result in reports

[trafford]

I want to use Dcount to return a value that I can post back into a report. This must be straightforward but I can't get it to work! The text below is in the report open event. Text44 is an unbound text box in the report. 'intx' is returning the correct value. I get the error 'can't assign a value to this object' and it breaks at the Me.Text44.Value line. What am I doing wrong?

====

Dim intx as String

intx = DCount("DAYS_BETWEEN_RECEIPT_AND_VAL", "TBL_APPS_REG", "[DAYS_BETWEEN_RECEIPT_AND_VAL] between 0 and 2")

Me.Text44.Value = intx

======

Thanks in advance for any help/guidance. Cheers

[Rabbit]

I want to use Dcount to return a value that I can post back into a report. This must be straightforward but I can't get it to work! The text below is in the report open event. Text44 is an unbound text box in the report. 'intx' is returning the correct value. I get the error 'can't assign a value to this object' and it breaks at the Me.Text44.Value line. What am I doing wrong?

====

Dim intx as String

intx = DCount("DAYS_BETWEEN_RECEIPT_AND_VAL", "TBL_APPS_REG", "[DAYS_BETWEEN_RECEIPT_AND_VAL] between 0 and 2")

Me.Text44.Value = intx

======

Thanks in advance for any help/guidance. Cheers

This is a roundabout way of doing it. Just set the control source of the text box to your DCount function.

Also, the reason it's not working is most likely because you're using the wrong event.

[trafford]

I see what you mean - thanks for your help

[Rabbit]

I see what you mean - thanks for your help

Not a problem, good luck.