 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / January 2008Calculation from a subform
I'm trying to create a calculation that includes 1 field from my main form. The calculation will be put on the subform. This is what I have for a formula in the control source field: =(Forms!PSHourlyRate!HourlyRate1-[TotalCost])/[TotalCost] It doesn't seem to be working. Am I missing something with the way this formula is set up? > I'm trying to create a calculation that includes 1 field from my main > form. [quoted text clipped - 6 lines] > It doesn't seem to be working. Am I missing something with the way this > formula is set up? It would probably be wise to first make sure you can get the value of the mainform into the subform before proceeding with a calculation; the syntax I would try is: Forms!MainFormName.ControlName the shortcut often works: Me.Parent.ControlName  SignatureNTC > I'm trying to create a calculation that includes 1 field from my main form. > The calculation will be put on the subform. This is what I have for a formula [quoted text clipped - 4 lines] > It doesn't seem to be working. Am I missing something with the way this > formula is set up? Hi It depends where your calculted box is If it's on the main from =Nz(SubformName.Form!ControlName,0)+Nz([MainFormControl],0) If it's on the subform =Nz([Forms]![MainFormName]![MainFormControl],0)+Nz([SubformControl],0) SignatureWayne Manchester, England. > I'm trying to create a calculation that includes 1 field from my main form. > The calculation will be put on the subform. This is what I have for a formula [quoted text clipped - 4 lines] > It doesn't seem to be working. Am I missing something with the way this > formula is set up? Hi It depends where your calculated box is as you need to refer to the form and then the control like this If it's on the main from =Nz(SubformName.Form!ControlName,0)+Nz([MainFormControl],0) If it's on the subform =Nz([Forms]![MainFormName]![MainFormControl],0)+Nz([SubformControl],0) In your case =(Forms!PSHourlyRate!HourlyRate1-[TotalCost])/[TotalCost] I’m not sure how you are getting [TotalCost], is this the name of a control ? or is it something else Also are you sure that all the controls have a value (ie. You are not using Nz) SignatureWayne Manchester, England. > I'm trying to create a calculation that includes 1 field from my main form. > The calculation will be put on the subform. This is what I have for a formula [quoted text clipped - 4 lines] > It doesn't seem to be working. Am I missing something with the way this > formula is set up? Is this the control source for a control on the subform? If so, where is this control on the subform (footer)? Assuming that [HourlyRate1] is field in the main forms record source, try: = (me.parent.HourlyRate1 - [TotalCost])/[TotalCost] HTH Dale SignatureDon''t forget to rate the post if it was helpful! email address is invalid Please reply to newsgroup only. > I'm trying to create a calculation that includes 1 field from my main form. > The calculation will be put on the subform. This is what I have for a formula [quoted text clipped - 4 lines] > It doesn't seem to be working. Am I missing something with the way this > formula is set up? Secret, Is this control on the subform? Is this control in the subforms footer? Is HourlyRate1 a field in your main forms record source? If so, try: = (me.parent.HourlyRate1 - [TotalCost])/[TotalCost] HTH Dale SignatureDon''t forget to rate the post if it was helpful! email address is invalid Please reply to newsgroup only. > I'm trying to create a calculation that includes 1 field from my main form. > The calculation will be put on the subform. This is what I have for a formula [quoted text clipped - 4 lines] > It doesn't seem to be working. Am I missing something with the way this > formula is set up? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.