title: Show on Main form the value of a Text box on sub form
body: <p>I have a sub form (continuous form) which shows the sum of Fee in a Text Box in the subform footer: </p>
  
  <pre><code>Text5 data =Sum(Fee). 
  </code></pre>
  
  <p>This works correctly. What I can't do is show that value in another Text Box on the main form. I have tried </p>
  
  <pre><code>TFees = Forms!frmInvoice![frmInvoiceDetails].Form.Text5
  </code></pre>
  
  <p>This shows nothing (Null?) on the main from. No errors. My data for the subform is:</p>
  
  <pre><code>SELECT 
      tblInvoiceDetails.InvoiceLookup, 
      tblInvoiceDetails.DiscLookup, 
      [ApplicantSurname] &amp; ', ' &amp; [ApplicantForenames] AS AppName, 
      [DBSFee]+[MyFee] AS Fee, 
      tblDisclosure.Client, 
      tblDisclosure.Payer 
  FROM 
      tblInvoiceDetails 
  INNER JOIN 
      tblDisclosure 
      ON tblInvoiceDetails.DiscLookup = tblDisclosure.ID 
  WHERE 
      (((tblDisclosure.Payer)='Client')) 
  ORDER BY 
      [ApplicantSurname] &amp; ', ' &amp; [ApplicantForenames]; 
  </code></pre>