Need Dlookup from one lookup value get result through 3 tables to different textbox

"Dear Experts

I have set of data table Dispatchcalls Total Column Field 43,Closedcalls Total Column Field 49 ,CancelCalls Total Column Field 40 and I have forms called ""SearchSerialNo Status "" In the form i designed data wizard forms with multiple textbox and cmd button.

I want dlookup from ""Entered Serial No"" where Input Value entered and click ""FIND SO's"" cmd button get result from Dispatch,closed,cancel tables

E.g In the Form First 12 FIELD textboxes Dlookup FROM Table-Dispatchcalls through lookup values of Entered serial No.
In the Form First 11 FIELD textboxes Dlookup FROM Table-Closedcalls through lookup values of Entered serial No.
In the Form First 2 FIELD textboxes Dlookup FROM Table-Cancellcalls through lookup values of Entered serial No.

Find the Zipattachment

1OnsiteDCC -Msaccess
2Example.xlsb file is attach of example for understanding my requirement



thanks in advance"

any experts could help me out?

Solved!!! Thanks for my experts