Not sure if i've used dlookup correctly but I am trying to grab a field from a previous record and put it in the current record, when I put the following code into the previous cost control source, it tells me there is a "Circular Reference" error. Please advise.
=DLookUp([Total Cost],[Field - Report Section],[Previous Cost]=[Forms]![Field - Report Section subform]![Total Cost]-1)
Thanks in advance.