I have followed the video instructions but the footer is not visible in my ProductSubForm so I am not getting the totals to display.  I deleted the form and re-created again following the video instructions, footer is still not visible and no total Qty is showing.  I copied the QtyOnHand box to the footer as instructed, right click on the box in the footer and open properties, Control Source is =Sum([QtyOnHand]) saved then closed and opened form.  No footer, no total.  What am I doing wrong?