Can someone please tell me what I'm doing wrong with my subtotal

[punter]

Hi,

I have a attached a zip folder of my database. It is has a form that has a subform. The form is named BOL information. I have a subtotal in the footer of the subform and a text box in the main form pointing back to it. What am I doing wrong? It seems right. I'm looking all over the place for the answer. Any help would be great.

Thanks

Eddie.

 

[KenHigg]

I think you need to put it in the footer

 

[punter]

I thought I did that. I'm just noticing now that I didn't. How do I do that?

Thank you for your quick reply.

 

[KenHigg]

First off you need to change the subform default view from datasheet sheet view to single form view. Then go to bottom of the subform and drag the bottom of the footer down so that you can see it. Then move the totals text box down in the footer... I think this is what you're ttying to do...

 

[punter]

I attached the updated verision of the database.

It seems the subtotals are now working in the subform. I put the text box in the footer of the main form that should give me the subtotal as I go along. I'm not sure what I'm doing wrong. It's really driving me crazy.

Thanks

Eddie.

 

[punter]

I was able to get it to work. It was werid. I was using the expression builder and access didn't like that. When I typed in the code similar to that in the Northwind database it worked. Odd.

Anyway, thanks for all your help.

Eddie.

 

[KenHigg]

You're welcome - Glad you got it to work -