Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 87
  • Last Modified:

Calculation on a field

Hello,

On my first form I have a calcualation field ..I need to carry that field into my second form...All these fields are on the table.

I was told to use the same calculation on the second form but just add the table name in front of the fields as these fields are not on the second form.

Can it be done this way?  All these fields are on my first form:

=Nz([Total Initial:],0)+Nz([BC1Chng1],0)+Nz([BC1Chng2],0)+Nz([BC1Chng3],0)+Nz([BC1Chng4],0)+Nz([BC1Chng5],0)+Nz([BC1Chng6],0)+Nz([BC1Chng7],0)+Nz([BC1Chng8],0)+Nz([BC1Chng9],0)+Nz([BC1Chng10],0)
0
Jass Saini
Asked:
Jass Saini
  • 3
  • 3
1 Solution
 
Jeffrey CoachmanMIS LiasonCommented:
carry that field into my second form.
Carry the Calculation or carry the value?

If the value, then just reference the control itself?
For example, ...If the control that holds your calculation is named "txtBigCalc"
Then simply make the control source of a textbox in the second form:
=Forms!YourFirstForm!txtBigCalc



You will have to explain what you are doing here a bit more (and explain why...)
Is the second form a subform or a standalone form?
0
 
Jass SainiAuthor Commented:
Hello,

I have an ending calculation on the first form that has to be the starting calculation on the second form..kind of like a ending balance and the second form is the beginning balance.
0
 
Jeffrey CoachmanMIS LiasonCommented:
...Then you should be able to reference the "value" as I stated, something like this:
    =Forms!YourFirstForm!txtBigCalc
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
Jass SainiAuthor Commented:
It gives me a #Name? error


I tried the subform name and the main form..niether work for some reason
0
 
Jass SainiAuthor Commented:
I add the calculation to my query
0
 
Jeffrey CoachmanMIS LiasonCommented:
Glad I could help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now