Any ideas why this would give me a circular reference error?
=IIf([Forms]![f_Month]![R_Catagory]="Extra",[Text21]=[Text8],[Text21]="")
Thanks.
Any ideas why this would give me a circular reference error?
=IIf([Forms]![f_Month]![R_Catagory]="Extra",[Text21]=[Text8],[Text21]="")
Thanks.
Try doing the if statement in the underlying query...
how would i do that if the text boxes are on the form?
Figured out how to make it work, still not sure why that was a circular reference but the formula I ended up using was:
=IIf([Forms]![f_Month]![R_Catagory]="Rent",[Forms]![f_Month]![Amount Debit])