title: subform footer disabled when allowAdditions =No
body: <p>I have a main form of <code>orders</code> and a subform of <code>Items</code>. The datasheet subform has a hidden footer which is equal to <code>=sum([price]*[quantity])</code>. On my mainform I have a textbox which is now equal to <code>=forms!orders.items.form.sum</code> this worked fine whilst <code>allowAdditions</code> on my subform was set to <code>YES</code> and shows the value of the hidden box. </p>
  
  <p>I want to set the <code>allowAdditions</code> of my subform to be <code>NO</code> so Items can only be added via a new popup form. However, this now causes an <code>#error</code> on my mainform total textbox. </p>
  
  <ul>
  <li>Can anyone help me with an alternative method or workaround?</li>
  <li>Any ideas on why the footer appears to be disabled?</li>
  </ul>