HI Every One
I'm having an odd ocurance with a subform
On the main form I have a field that you enter in an item number. The item discription and cost are added to the subform table and is requeryed so the new item is displayed .
In the subform footer I have a field doing a sum on the cost field and I display that total on the main form.
All this works Great untill I get to bottom of the subform window with items. as soon I pass the end of the window the totals stop working. I can still enter more items with no problems, scroll up and down to see all the items, Just the total is now 0
if I delete items untill total amount of items is not longer the the subform window the total starts working again
It makes no differance as to the length of the subform window big or small.
Subform:
set to continious form
vertical srcoll bar only
Sum of field in subform footer
any Idea greatly apreceiated
I'm having an odd ocurance with a subform
On the main form I have a field that you enter in an item number. The item discription and cost are added to the subform table and is requeryed so the new item is displayed .
In the subform footer I have a field doing a sum on the cost field and I display that total on the main form.
All this works Great untill I get to bottom of the subform window with items. as soon I pass the end of the window the totals stop working. I can still enter more items with no problems, scroll up and down to see all the items, Just the total is now 0
if I delete items untill total amount of items is not longer the the subform window the total starts working again
It makes no differance as to the length of the subform window big or small.
Subform:
set to continious form
vertical srcoll bar only
Sum of field in subform footer
any Idea greatly apreceiated