Value from IIF statement

[aattas]

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

 

[arnelgp]

you can directly put the Expression on catone field.

 

[aattas]

Thanks .I will try

 

[theDBguy]

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