Hi Everyone,

I'm stuck on an UPDATE sql command. I keep getting an error message that says that i'm missing an operator. I am trying to get the HighPoint to subtract from the Amount in the text matrix where the item number in rsItemNumber equals the text matrix Itemnumber. What is wrong with what I am doing?


rsItemBalance.Open "UPDATE ItemBalance SET HighPoint = HighPoint - " & msgViewToday.TextMatrix(1, 0) & " WHERE ItemNumber = " & msgViewToday.TextMatrix(1, 1) & "", _
cnn, adOpenStatic, adLockOptimistic