currently i have the update query which is working. but i need that query should look up on form for input and then run.
If you are copying data from one table to another, don't. It is poor design strategy to duplicate data. When the source data changes, what prompts the copies to be updated? -- that's why we don't do it. Always do the calculations in a query at the point in time where you need them.