Problem with subtotal

[punter]

Hi,

The attached database has a form called Broker Information. There is a text bottom at the bottom of the form that relates back to a text box that sums a column in the subform. For the life of me I can't figure out why is it now working. It looks exactly like every other form I have set up with totals but this one doesn't want to come through. Any thoughts on what I'm doing wrong?

Thanks

Eddie.

 

[punter]

Hi again,

I'm not sure if I expressed myself clearly enough the first time. Reading back on it I don't know if I gave enough information.

The attached database (see first post above) has a form called Broker Information. Within that form is a subform called 02-28-07Query subform. In the footer of the subform is a text box named Text24. That text box is summing the total of column Dollar_One in the 02-28-07Query subform.

In the footer of the form Broker Information there is a text box named Text48. That box should be showing the contents of the Text24 box in the 02-28-07Query subform.

The problem I'm running into is that the Text48 in the footer of the Broker Information form is not holding the summing the data. If I click on a cell within column Dollar_One in the subform Text48 will show that amount but it doesn't sum the amounts if I enter multiple lines of data.

Any thoughts on what the problem is? This is REALLY driving me nuts. I've put together various forms before and everything looks exactly the same. I'm not sure what mistake I'm making. Any help would be most welcome.

Thanks as always.

Eddie.

 

[punter]

I was able to figure it out. Thanks anyway. This is issue is closed.

Eddie.