In access I have Form name FB (table name = FB) and SubForm name FBB ( table =FBB) (relationship one to many)
I use
( currentdb.execute "insert into FBB (FBID, ProductName, Quantity) "& _value (" & me.FBID &",'" & me.ProductName &"','" & me.Quantity &"')
What i want now is how if ProductName is a duplicate update the value Quantity by sum with me.Quantity in the same FBID
And thank you in advance
I tried to use on duplicate update the key but doesn't exist in access