You simply ROCK. This worked so smooth. This is exactly what I wanted. This works when the subform is Open as well as close. I have added a Refresh Button in my Main Form to refresh my data in Main Form every time after I update my subform. Thanks a million.
In the afterupdate event for text21:
It's hard to understand the process due to textbox control names like text25, text21, etc.Code:tempvars!totalPrice2 = text17 + text23 'calculate it just like text25
These should be named something like txtTotalPrice2 and txtMarkupPct. It would make things much less confusing.
Glad to help. Keep plugging away - good luck with your project!