If statement in Continuous sub form (2 Viewers)

aattas

Registered User.
Local time
Today, 18:44
Joined
Dec 24, 2014
Messages
75
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
 
use conditional formatting.
 

Users who are viewing this thread

Back
Top Bottom