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

J

juggernauts

Joined
Mar 28, 2014
Messages
2
Reaction score
0
Hi,

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.

Juggie
 

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

Similar Threads

Need help to Simplify a Complex Calculation on a Form 0
Struggling with Calculated Field on Form to Main Form/Table 2
calculating a total of a calculated field on a subform 5
Pass Data from Unbound Form to Bound Form 2
Calculated fields in main form based on criteria in sub form 3
pass a calculated form field to a subform field? 22
Problem with calculated controls with data from subforms 8
Storing Calculated field...I know..I know... 8

Top