mabino79201

[mabino79]

have Sub Form containts product ID & Qty

Want total of Qty which product selected on main form.

 

[mabino79]

is this solve the

=DSum([Qty],[tblInventoryTransaction]![ProductCode]=[ProductCode])

 

[mabino79]

=[tblInventoryTransactionSubForm].[Form]![Text83]

getting error retrieving value from sum form in main form

 

[pbaldy]

Not much info to go on, but if you mean when the subform is empty try:

Forms: #Error when the Subform has no records

 

[diari]

a është kjo zgjidhje

=DSum ([Sasia],[tblInventoryTransaction]![Kodi i produktit]=[Kodi i produktit])

Expr1: DSum ("[Sasiah]-[Sasia]","Baza","[Barkode]='" & [Barkodi] & "'")

 

[diari]

is this solve the

=DSum([Qty],[tblInventoryTransaction]![ProductCode]=[ProductCode])

Expr1: DSum("[Qty]","tblInventoryTransaction","[ProductCode]='" & [ProductCode] & "'")