HillTJ
To train a dog, first know more than the dog..
- Local time
- Today, 04:23
- Joined
- Apr 1, 2019
- Messages
- 731
Friends, I have a form with a field that is populated with a number that the user can change. That number is used to do some calculations on a field of an embedded datasheet style subform. Pretty usual. The calc on the subform is triggered by the user selecting a record from a combobox. All works perfectly. Now, I'd like to add the functionality that if the user changes the value of the field on the mainform, then each subform record is recalculated to reflect the result of that value. I'm thinking that I have to iterate through the recordset of the subform then go to the recalc subroutine for each record. If I've made sense?
Is this the correct approach? Appreciate your advice as always.
Is this the correct approach? Appreciate your advice as always.