Change subtotal when datasheet is filtered

[vmon]

I have a mainform and subform. I have a subtotal in the footer of the subform that is displayed on the mainform. I am trying to have the sutotal reset based on the exclusion of records using the right click filter menu.

Is this possible? How?

Thanks,
vmon

 

[jmrSudbury]

Try using =Sum([AmountField]) as your total field in the form footer.

John M Reynolds

 

[vmon]

Try using =Sum([AmountField]) as your total field in the form footer.

John M Reynolds

I have tried this and it is not working. Is there a settin that would prevent it from updating as records are filtered?

vmon

 

[jmrSudbury]

I tried it and it worked fine. The top form is unfiltered where the bottom only shows the one value:

The box in the footer of the sub form has =Sum([amt]) as its control source.