Adjusting the size of a subform using code

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have a subform that has a "TOTALS" textbox that is a calculated field. The
number of line items in it will change for each customer. I tried adding up
the heights of the form header & footer(0.1667) + Count of line items *
0.1667 so that the TOTALS will be right under the last line item. The CanGrow
and CanShrink on the subform and the subform details section are set to Yes.
I tried running this code and refresh the form and it does not work....

Any ideas?

TIA Craig
.

Relevant Pages

  • Check box changes formula used in subform
    ... I have a subform for listing parts. ... NET PRICE, LIST PRICE, Quantity, Supplier, and a calculated field called Part ... hidden text box on my subform that calculates the sum of all the Part Totals ...
    (comp.databases.ms-access)
  • Need check box to change formula used in subform source
    ... I have a subform for listing parts. ... NET PRICE, LIST PRICE, Quantity, Supplier, and a calculated field called Part ... hidden text box on my subform that calculates the sum of all the Part Totals ...
    (comp.databases.ms-access)
  • Form developed in Access 2003 losing functionality in Access 2002
    ... each customer on the parent form. ... I have two buttons on the subform which will add or delete a new record. ... It fails to recalculate the totals on the main ...
    (microsoft.public.access.forms)
  • RE: Totals Row Not Summing
    ... to SUM, but it doesn't calculate a sum. ... Let's say your subform text box control is txtCost and it's ControlSource is ... I enabled the totals row on the two datasheet subforms, ...
    (microsoft.public.access.forms)
  • Re: Refresh main form from sub form
    ... And when you need to force Access to update the calculated controls on a ... > meals on the subform the Dlookup wasn't refreshed. ... > Refresh on the main form I realised I was probably going the wrong way. ... then totalled them and used the totals as datasource for total boxes ...
    (microsoft.public.access.formscoding)