Help! I am slowly losing the will to live :(
I have a control on a subform that uses the DLookUp function to get a numerical value from a query.
When I use the following in the subform it works fine:
=DLookUp("[TotNoDays]","qryHolEntitCalculation","[HPIDNo]=" & [Forms]![HolidayTakenForm]![...