Hi there, try this example:


"Update members set lastname=' " & Replace(txtInputName,"'","''") & " ' "

I got this from the searchVB.com which they provide
great VB tips and misc stuffs. You might want to
subscribe yourselft because it is free!