using sum on two subforms for main form

[scottappleford]

hi

i have a stock control db. when new stock is ordered it updates 'units on orders' field, then when goods are recieved the subform field is updated and this automatically updates the 'units on hand field'.

i then have another subform for stock going in and out, i would like to be able to have the units on hand field as above (which is the main form) automatically updated like is when using the the goods recieved sub form??

not sure if i explained it properly but i can send the structure if that helps?

many thanks

 

[aleb]

I know that you have resolved the issue but for the reference

http://www.mvps.org/access/downloads/syntax_for_subs.zip