response to pat harman
Because what I have is a main form with a list of parts. Beside this list of parts is a total on hand which the main forms recordsource calculates. The second form that is opened allows the inventory to be updated and after it's updated I need the correct total on hand to be displayed. So I am requerying the main forms recordsource to recalculate the totals. Hope this makes since. I am new to access and vba so if you have a better idea on how to accomplish this please let me know. The reason I am not using a subform is because my main form is set to continuous then I positioned the details form on the right side of the screen so I can view the details and be able to see multiple parts with there totals all at once.
