I have tried that way too. If I enter details in the field it sholud update in the database too. But it is showing only on the form.. not adding to database..
SQL = "UPDATE itemsSET Item='"&item&"', company= '"&company&"' WHERE Itemid = " & itemid
But no luck.