Need another set of eyes here. I get error 3134, syntax can insert into.... on first "DoCmd.RunSQL..." at end of code.
Table has many fields, I only need these 3 populated when 'insert into' on the record.
'-=-=-
Private Sub ItemBinLocationMove_Click()
Dim vOldBinLoc, vNewBinLoc...