updatable/non updatable data in datasheet

[supa_sumo]

Ok ive been having this sort of problem for a while. Ive been trying to display updatable and non updatable data in a datasheet form. The problem is that i couldnt update any of the details with a calculated field in the table. Therefore i have put the calculated field in a subform thanks to someone on the forums request(sorry i cant remember who it was). After referencing the subforms text box i can display the correct information in form view however i cannot display in in datasheet view without expanding the subform [+] for the form to do the calculation. I need the form to go through all records once it opens unless anyone has a better solution. Hope sumone can help,
Thanks Sci

 

[Pat Hartman]

I can't tell what calculation you are trying to perform but if it is an aggregate function such as Sum(), Avg(), Count(), etc, add a footer to the form/subform and add a control there to perform the function. The footer/control doesn't need to be visible unless you want to see it.