Search results

When i use dsum i need to use with it.dlookup and iif functions Thus becoming a complex expression i can not creat.it

The purpose of this process is to know that there are values ​​<> 0 within the text2(subform) by other way.can i creat command button in main form to know that in any values without specified within text2(sub form) is <>0 by msgbox

I know that. But there is a way to sum this field. is not silliness that I can not sum field

I know that but this form for add and edit data As you see all texts box in main form are unbounded

This is just a sample And voucherno should be a textbox for The user innput the number he wants

Thank you for quick response I have attached a sample

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 = DLookUp("balance","qn7","[idproduct]=" & [Forms]![fautt]![autot].[Form]![idproduct] & " and [idstore]='" &...