I have a subform embedded in a main form, the subform has a field (text box) that is doing automatic calculation so no manual entries are needed from the user. I have tried to pass automatically the final result to a text box in the main form, but all events are not working (afterupdate, On change, On Dirty), etc.

I have a button to do the above mentioned in the main form, but I don’t want to use that button, I want to do all the process from the subform.

Also, from the subform I was able to do click on the button on the main form (programmatically), however MS Access is too quick and the value extracted from the subform is always empty (zero); Acees is finishing before the calculation is done.

I did search in the internet, and I expend too many minutes trying to find a solution but until know I have not been successfully.

I am using MS Access 2010.

Any help will be highly appreciated.

Thank you,

Fabio