ok guys..
i dunno what exactly happen..i think i done it at right way..
ok..i create Main Form that contain 2 (material and workmanship) subforms. subfrom i create using wizard from query
then i use =Sum([TotalAmount]) at subform footer to calculate total price from selected part (i create workshop's part management system) n it works fine..for both subform..
but another prob here..
at Main Form that contain material n workmanship subform. i want to calculate Grand Price, where it from TotalAmount from each subform..
i create 2 dummy control (to hold TotalAmount from each subform,coz i think its hard to make sum for 2 TotalAmount), 1 for material n 1 for workmanship..
then i want to sum 2 dummy control into Grand Price box...
but when i use =MaterialSubform.[Form]!TotalAmount at dummy's ControlSource it failed.. show #name?..
y? am i missing sumting at my Main form or subform? plz help me..
i want to send attachment but my fileto big to send...
*(i hope u can understand, coz my english not good ^_^)
i dunno what exactly happen..i think i done it at right way..
ok..i create Main Form that contain 2 (material and workmanship) subforms. subfrom i create using wizard from query
then i use =Sum([TotalAmount]) at subform footer to calculate total price from selected part (i create workshop's part management system) n it works fine..for both subform..
but another prob here..
at Main Form that contain material n workmanship subform. i want to calculate Grand Price, where it from TotalAmount from each subform..
i create 2 dummy control (to hold TotalAmount from each subform,coz i think its hard to make sum for 2 TotalAmount), 1 for material n 1 for workmanship..
then i want to sum 2 dummy control into Grand Price box...
but when i use =MaterialSubform.[Form]!TotalAmount at dummy's ControlSource it failed.. show #name?..
y? am i missing sumting at my Main form or subform? plz help me..
i want to send attachment but my fileto big to send...
*(i hope u can understand, coz my english not good ^_^)