Syntax (1 Viewer)

[Smart]

I am using a stored procedure to update a table
Con.Execute ("Exec sp_Update_People_Root_Cause '" & Me!TxtbehaviourDriver & "','" _
& Me!txtRootID & "','" & Me!Person_Responsible & "','" & Me!DTPicker9 & "','" & Me!cmbLevel_1_ID & "','" _
& Me!CmbLevel_2_ID & "','" & Me!CmbCustContacts & "','" & Me!TxtResponsibletxtBox & "','" & Me!Underlying_Type_ID & "','" _
& Me!ChkMultiplereq & "','" & Me!ChkInDispute & "','" & Me!ChkOther & "' ")

The following paramater Me!Person_Responsible errors because it contains an apostrophe eg martin o'neil
do i need to surrond the parameter with a different type of syntax ?

Help please

 

[pdx_man]

Funny, I just had to do this yesterday.

... & Replace(Me!Person_Responsible, "'", "''") & ...

You have to replace the single quote with two single quotes.

 

[Smart]

syntax

Thanks PDX man it worked like a dream