>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
If it's not broken, fix it until it is.
My Blog