can some one help me whats wrong with this statement. i have tried everything and can't get it to work.

mycomm.CommandText = "Update quotes Set ID='" & Replace(TextBox3.Text, "'", "''") & "',CustomerName='" & Replace(TextBox1.Text, "'", "''") & "',DateReceived='#" & Replace(TextBox4.Text, "'", "''") & "#',DateRoutingComplete='#" & Replace(TextBox5.Text, "'", "''") & "#',DateMaterialComplete='#" & Replace(TextBox6.Text, "'", "''") & "#',DateQuoted='#" & Replace(TextBox7.Text, "'", "''") & "#',DateClosed='#" & Replace(TextBox8.Text, "'", "''") & "#' Where Id = " & QuoteIDhold & ";"

What does it look like if you print the value of mycomm.CommandText?