Need help on how to pass calculated field from a form to another form

Mar 28, 2014
Reaction score

I need your expert advice on how to get calculated result on a subform of Form A to subform of Form B

For example, below is my calculated fiekd in Form [frmStockSearch]
=Nz(DSum("[Qty]","tblPurchaseOrderDetails","[SentTo] = 'Store' AND [ItemCode] = " & [Forms]![frmStockSearch]![ID]),0)
-Nz(DSum("[Qty]","tblOrderDetails","[SentFrom] = 'Store' AND [ItemCode] = " & [Forms]![frmStockSearch]![ID]),0)

I want to use the same calculation result in Form [frmStockSearchClient]. I know I can copy the same code by changing [frmStockSearch] to [frmStockSearchClient], but it is tedious as I have many calculated fields and many forms.

Thank you for your help. I greatly appreciate that.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question