I found the problem I had the data path in the sql select statement. It gave me a ado record set with the right data but it would not update it.
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers