Navigation Form Requery

[jamescullis]

I've got a Navigation Form set up and are looking to requery the subtotal of one of the forms AFTER I have added data to a subform within it. (Image zipped)

The subform requery's the totals ok when I add a product, just can't seam to get the form to requery without having to put focus on the field

ProjectsMain.NavigationSubform>OrderProductDetails

Control Names
- OrderSubtotal
- ShippingSubtotal

I've tried almost every EVENT to requery the value but nothing seams to work

I'm not sure this is the problem but I think it's the navigation subform structure causing the issue.

Process
- Form OrderProductDetails loads
- Select Add Product or ItemNumber from the subform
- - New Form opens where I add the product and close that form
- The subform refreshes within OrderProductDetails with the correct data loaded
- Now I need to display the correct totals without having to select the 2 controls.

your thoughts please?

 

[jamescullis]

I get the impression Macros aren't popular here!

 

[BlueIshDan]

Even thought you have provided your process, I don't feel that there is enough tangible information here for me to go by. If you could provide a bit of clarity for me, I would be glad to help.