Date Difference Help

[Guest]

I am trying to create a date difference formula on a form that has a subform,
so far I am getting ?name in the field.

The formula I am using is
=DateDiff("d",[Forms]![frmAllocated]![ResponseDate],[DateReceived]), as you
can probably work out from the formula, the Response Date is in a sub form on
the main form, and the Date Received is in the main part of the form.

The field where date difference is, is on the main form also.

I have also noticed that the subform field loses its[] brackets when I go
back and try to think of something I have missed off the formula.

Could anybody point me on the right direction?

 

[Van T. Dinh]

You need something like:

=DateDiff("d",
[SubformCONTROLName].Form![ResponseDate],
[DateReceived])

(type as 1 line). You need to check the SubformCONTROL name in the
DesignView of the main Form.

For more info, see the Access Web article:

http://www.mvps.org/access/forms/frm0031.htm