Recalculate Main Form Data

[bbrendan]

Hi All,

I need a little help with trying to re-query a mainform box

Heres the deal.

I have an order entry form which is made up of 2 forms, Main form and Sub form. The main Form has all the customer information, and order total fields.
An example of thie is [Order Total]

The subform contains the Line Details

The problem is that when-ever I enter a new line onto the subform the main form [order total] does not update.

The [order total] box has the following code.

=([SubTotal]+[ShippingCost]+[TotalTax])

These fields are summary fields I have placed in the footer of the sub form to calculate out the line totals.

The strange thing is that when I put put the cursor into the main form [Order total] Box I can see the updated value.

Its as if im not refeshing the [order total] box!.

I have tried putting
after update on the sub form
forms!frm_main.[order total].requery - this doesnt fix it!
also tried

forms!frm_main.[order total].refresh - Doesnt work Errors out

Anyone got any sugesstions as to why this is behaing like this???

thanks

 

[bbrendan]

Hi Pat,

thanks for your help. You pointed me in the right direction.

Ive just put some code behind the after update events

forms!frm_main.refresh

This refreshes the whole form, like the docmd does.



cheers