I have a from with a subform within. On the form you can seach for a Part No that can retrieve multiple ammounts on a subform how do i crate a field on the main form that adds up the total stock in the subform and displays.
I would try using the dSum function. You may have to write the criteria in VB to get some of the variables in, then requery the text box when you subform changes
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.