Value from IIF statement (1 Viewer)

gents,

I have a report that has an IIf statement (unbound field) as follows:
=IIf([First of Codecat]=2,[AccessTotalsFORWARDTO]*1)

=IIf([First of Codecat]=3,[AccessTotalsFORWARDTO]*2)

=IIf([First of Codecat]=0,[AccessTotalsFORWARDTO]*0)

the result came out perfectly, but when i want to use the resulted value in VBA or Query. The system says no such value even though I created a field to transfer the IIF value to it as follows:
me.catone.value = me.text22.value

catone is the new field, and text22 is the unbound field creating the IIF.

Why the system do not recognize the value resulted from IIF as a valid value.

Thanks

you can directly put the Expression on catone field.

Thanks .I will try

Hi. If it still doesn't work, can you show us how you tried to use the value in VBA? Cheers.