Help with syntax. What am I doing wrong
Al,
You are missing a space before the "WHERE" clause. Print strSQL to the
immediate window and then try to run the query in the query builder it will
generally be apparent where your errors are.
Quote:
> The following syntax on current event giving me a missing
> operator in the [SpantranID] = .....
> here is my code
> strSQL = "UPDATE tblClientDetails SET Balance_Refund
> = 'Balance:'" _
> & "WHERE [SpanTranID] =" & Me![ SpanTranID] & ""
> what am i doing wrong?
> thanks
> Al
