Hello
I have six fields in a subform
Text1
Text2
Tex3
Idproduct (number)
Idstore (text)
Qnty (number)
Main form "fautt"
Subform name "autot"
Access2007
Text1 =
And text2 =
Everything works well till now
But The bug is
I tried to make text3 as
sum to text2 field values
I tried more than a hundred times but I failed
Any help ?
I have six fields in a subform
Text1
Text2
Tex3
Idproduct (number)
Idstore (text)
Qnty (number)
Main form "fautt"
Subform name "autot"
Access2007
Text1 =
Code:
DLookUp("balance","qn7","[idproduct]=" & [Forms]![fautt]![autot].[Form]![idproduct] & " and [idstore]='" & [Forms]![fautt]![autot].[Form]![idstore] & "'")
Code:
IIf(([text1]<[Qnty]),([text1]-[Qnty]),0)
But The bug is
I tried to make text3 as
sum to text2 field values
I tried more than a hundred times but I failed
Any help ?