Expression builder error, circular reference

[cowboy]

Any ideas why this would give me a circular reference error?



=IIf([Forms]![f_Month]![R_Catagory]="Extra",[Text21]=[Text8],[Text21]="")

Thanks.

[dsmacs]

Try doing the if statement in the underlying query...

[cowboy]

how would i do that if the text boxes are on the form?

[cowboy]

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])