SUBFORM CODE IN VERSION 2003 AND 2007

[NEOFYTOS]

hello my name is neofytos

i have a text box in a form with the following code

=IIf([EdafoponikiMorfi]=8 And [EdafoponikiDescription] Is
Null;"1";IIf([EdafoponikiMorfi]=9 And [Platos] Is
Null;"2";IIf([EdafoponikiMorfi]=1 And [StandOrigin] Is
Null;"3";IIf([EdafoponikiMorfi]=1 And [StandOrigin]<>1 And [F_TexnitiRecords
subform].[Form]![TexnitiId] Is Null;"4";"OK"))))


this code works properly in Access 2003
but do not work properly in access 2007 (this happens only for the part that
refers to the subform) IIf([EdafoponikiMorfi]=1 And [StandOrigin]<>1 And
[F_TexnitiRecords subform].[Form]![TexnitiId] Is Null;"4";
all others work properly but this part do not work.