Hi insert command works update does not do anything any help Please
SqlTimes.InsertCommand = "insert into athletedata([Athlete],[Mydate],[session],[mytime]) values ('" & athletename & "','" & storedate & "','" & todaysession1 & "','" & savetim1 & "') "
SqlTimes.Insert()

                        SqlTimes.UpdateCommand = "UPDATE Members  SET [Agegrade]=('" & savetim1 & "'where [Fullname]='" & athletename & "') "
                        SqlTimes.Update()

From my opinion your SQL Statement should be

SqlTimes.UpdateCommand = "UPDATE Members  SET [Agegrade]='" & savetim1 & "' where [Fullname]='" & athletename & "'"
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.