Hello,
I have two slightly annoying issues. I have a DLookup formula on my data sheet subform that is working, however, in the next blank record, that field has an #Error message which is a little irritating to see. But when I key in data the #Error goes away. Below is the formula:
A similar thing is happening in the total field. The formula is working but in the next blank record the field where the formula is, is displaying #Type! which remains until I key in data. This is the formula:
Any idea why two working formulas would display these errors in the blank records?
I have two slightly annoying issues. I have a DLookup formula on my data sheet subform that is working, however, in the next blank record, that field has an #Error message which is a little irritating to see. But when I key in data the #Error goes away. Below is the formula:
Code:
=IIf([PrgmID]="0"," ",DLookUp("[Rate]","tblPrograms","PrgmID=" & [PrgmID]))
A similar thing is happening in the total field. The formula is working but in the next blank record the field where the formula is, is displaying #Type! which remains until I key in data. This is the formula:
Code:
=IIf([PrgmID]="0",[OtherRate]*[Qty],[txtPrgmRate]*[Qty])
Any idea why two working formulas would display these errors in the blank records?