Originally Posted by JANR
You cannot use Values if you use a where-clause, you must use Select.
I assume andnum is a number variable so:
"Insert Into [China Ops] ([Amnedment Number]) Select " & andnum & " Where Item='" & glb_CHIITEM & "'"
correct - amdnum is a variable
okay i made the adjustments (aka copy and paste) and im getting another compile error
Expected: line number or label or statement or end of statement
doesnt make sense to me :s