Solved Physical Inventory Adjustment

[CJ_London]

it won't because the recordsource to the form is too complex. Your method is not the right way to go and I don't want to spend time trying to get round the problems of a poor design. Best I can suggest is look into using a dlookup or dsum as a controlsource to a control

 

[ahmad_rmh]

Thanks,

CJ_London, For your possible solution of dlookup function.

Its works and has provided me the results.