Hi,
As shown in image below. I have managed to get a Total Row in my Datasheet form by pressing the Sum Sign from the Access Toolbar at the top. Based on drop down manual selection, the Total Row will do different calculation for the table fields.
However, I need it to be fixed on a selection like Sum and does it automatically without the need for the manual select. Also I need to stop users from changing it. Is there any way to control its properties or behavior.
Thanks
Sahm
![]()