ty for the reply but i get this error Syntax error (missing operator) in query expression 'SUM(Accessory_Table.Qty * Accessory_Table.Cost) FROM Stock_Table INNER JOIN Accessory_Table ON Stock_Table.StkCode = Accessory_Table.StkCode'. this is my actual code "UPDATE Stock_Table " & _ "SET StkCost = SUM(Accessory_Table.Qty * Accessory_Table.Cost) " & _ "FROM Stock_Table " & _ "INNER JOIN Accessory_Table " & _ "ON Stock_Table.StkCode = Accessory_Table.StkCode" maybe UPDATE and SUM doesnt really work together in access?

maytel mynt wrote: using access So use File-->Get External Data-->Import to import the tables you want. -------------------------------------------------------- Knowledge is knowing that the tomato is a fruit. Wisdom is not putting it in fruit salad!!

done cleaning usercontrol solution and the new application soultion it still doesnt debug they way it was before. this works if myfunction() then but this doesnt if usercontrol.reccount = 0 then already set debug build in configuration manager of new application but still no success

ty for the jumpstart