Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Calculation on a field

Posted on 2015-01-30
6
Medium Priority
?
85 Views
Last Modified: 2015-02-03
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
Comment
Question by:Jass Saini
  • 3
  • 3
6 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40580980
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
 

Author Comment

by:Jass Saini
ID: 40584191
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
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 40585352
...Then you should be able to reference the "value" as I stated, something like this:
    =Forms!YourFirstForm!txtBigCalc
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Jass Saini
ID: 40586752
It gives me a #Name? error


I tried the subform name and the main form..niether work for some reason
0
 

Author Comment

by:Jass Saini
ID: 40586879
I add the calculation to my query
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40586985
Glad I could help.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question