Jass Saini
asked on
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([BC 1Chng2],0) +Nz([BC1Ch ng3],0)+Nz ([BC1Chng4 ],0)+Nz([B C1Chng5],0 )+Nz([BC1C hng6],0)+N z([BC1Chng 7],0)+Nz([ BC1Chng8], 0)+Nz([BC1 Chng9],0)+ Nz([BC1Chn g10],0)
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]
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It gives me a #Name? error
I tried the subform name and the main form..niether work for some reason
I tried the subform name and the main form..niether work for some reason
ASKER
I add the calculation to my query
Glad I could help.
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!txtBi
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?