View Single Post
Old 08-03-2011, 06:07 AM   #5
What say you, good sir?
Join Date: Jun 2011
Location: Toronto (GTA), Ontario
Posts: 81
Thanks: 12
Thanked 0 Times in 0 Posts
AC-Dev is on a distinguished road
Re: compile error: expected: expression

Originally Posted by JANR View Post
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
AC-Dev is offline   Reply With Quote