AH, the light has shown. :D

>>Hi Naomi,
>>I only see one comma period after the address field. ?:)
>
>Right and it should not be there since it's the last field.
>
>>>Hi Beth,
>>>
>>>He has one extra comma after the Address field. Look closer at the string.
>>>
>>>>Dim sqlUpdate As String
>>>>sqlUpdate = " Update Customer " & " Set Name = ' " & Name & " ', Address = ' " & Address & "'," & " Where PhoneNo = '" & Key & "'"
>>>>
>>>>HTH,
>>>>Beth