If statement in Continuous sub form

[aattas]

Gents,
I have a report that has the combination of Main form and continuous sub form. In the sub form there are two fields that i am using the If statement. The If statement works fine but the result applied to all the entries in the subform, despite the condition field is different form one to another. to illustrate:
the field .....( Final Status) and the (days remain)

If me. Finalstatus = " close" then
me.daysremain.visible= false
end if
Not all are " close" some has " open" some has "pending".
But the result of the code applies to all status. so if i close one all the "days remain" fields are gone.
Please help

 

[arnelgp]

use conditional formatting.