Subform Update

[franc_5791]

Hi All

I have tried my best to sort this out and reached a point where my brain has stopped working completely.

I am creating a invoicing system and there is header and line level details.

Header details are on the main form and line on the subform.

I have a label on the main form that when clicked generates the invoice. QTY, PRICE and TOTAL (TOTAL is the calculated QTY * PRICE) are the fields on the subform and the sum of total is on the main form. The problem is after entering the qty and price fields ifI tab to the next rec, the value is updated in the main form total. But if I enter the price and directly click the label on the main form the invoice is generated but with out the last line and also the main form total does not include the last line.

Your expert help is appreciated.

Franc

 

[Tidy]

Can you reword your message above. I'm trying to understand your problem.

 

[Rabbie]

Possibly posting your DB would help us to understand the issue

 

[gemma-the-husky]

what code is the main form label/button click running? Is it a query, or are you using code to get the totals?