dgambale@gmail.com
Registered User.
- Local time
- Yesterday, 23:52
- Joined
- Jul 31, 2013
- Messages
- 19
Hello,
I have form that uses the datasheet view as the default view. I have a subform within the datasheet where I am summing up a field call Quantity by putting an unbound field in the footer of the subform and referring to it in the main datasheet view.
The calculations seem to work but in the datasheet view the Summed data of the subform is initially shown as #Error. However when I click on the "+" button within the datasheet the calculation is performed for that row and all looks good.
The question is, how do I get every row to automatically calculate the data from the subform without having to go into each individual record by pressing the "+"? Right now it just shows #Error until I click the +
Thanks for the help
I have form that uses the datasheet view as the default view. I have a subform within the datasheet where I am summing up a field call Quantity by putting an unbound field in the footer of the subform and referring to it in the main datasheet view.
The calculations seem to work but in the datasheet view the Summed data of the subform is initially shown as #Error. However when I click on the "+" button within the datasheet the calculation is performed for that row and all looks good.
The question is, how do I get every row to automatically calculate the data from the subform without having to go into each individual record by pressing the "+"? Right now it just shows #Error until I click the +
Thanks for the help