Subform calculation

[Guest]

Hi,

Here's my problem. I have a form with 3 subforms on it. The subforms are
linked to an option group that, if clicked, filters the subforms' underlying
query. The subforms are then updated and display the new values. Works
fine. On my form, I have a text box to compute totals from all three
subforms. The first time I make a selection the total computes correctly.
However, on all subsequent selections, I get #ERROR for the text box value
(the subforms still load correctly). Why is this happening and what is my
solution?

Thanks

 

[John Vinson]

The first time I make a selection the total computes correctly.
However, on all subsequent selections, I get #ERROR for the text box value
(the subforms still load correctly). Why is this happening and what is my
solution?

Well, you'ld need to post your code to diagnose it for sure - but try
putting in a line

Me.Recalc

in the event which changes the data being totalled.

John W. Vinson[MVP]