Insert into when field has a slash "/"

[carmenv323]

Hello, this is my sql in vba code



db.Execute "Update tblEOS Set tblEOS.[SCOPECAT] = " & Me.cboBusinessUnit & ">" & Me.cboWorkType & ">" & Me.SCOPECAT & _
" where ttblEOS.[RequestID] = " & Me.RequestID, dbFailOnError


but the value has a slash and I'm getting an error. how can I get around this?

[ranman256]

what has the value w slash?

"Update tblEOS Set tblEOS.[SCOPECAT] =' " & Me.cboBusinessUnit & ">" & Me.cboWorkType & ">" & Me.SCOPECAT & " ' where ttblEOS.[RequestID] = " & Me.RequestID

SOPECAT is text so it should allow the slash, but it did need 'string delimiters'
Me.RequestID CANNOT have a slash, it must be numeric.

[carmenv323]

Thank you for your input, I realize that I was inserting the wrong id value into RequestID and it wasn't finding it. That was the error.

[June7]

Should probably save these elements to separate fields instead of concatenated into one. Why save with ">" character?

You may have corrected RequestID input but the SQL should still fail.