Unable to do UPDATE

M new here.I try to do change my password but unable to change it... The error is the one i put in italic,mentioning Object Variable required... may i know what goes wrong with my code..Please help .Thank you.

VB Code:

....[ If Not CheckPass_Rs.BOF Then
            CheckPass_Rs.MoveFirst
            str_Password = CheckPass_Rs!Password
            If Trim$(UCase$(Old_Tbox.Text)) <> str_Password Then
                MsgBox "Invalid old password"
                Old_Tbox.Text = ""
                NewPass_Tbox.Text = ""
                Verify_Tbox.Text = ""
                Old_Tbox.SetFocus
            Else
                [I]oSQL[/I].Execute "UPDATE UserMaster SET Password = '" & UCase$(NewPass_Tbox.Text) & "' where User_Id = '" & UCase$(UID_Tbox.Text) & "'"
Call MsgBox("You have successfully chosen a new password", vbInformation, "Password Changed")
            End If
        End If

Welcome to the forums! :)

How did you declare oSQL? It should be a connection or command object...

frimily:

Password is a reserved word/keyword and therefore, when you use any keyword to name database objects, you must delimit them within the sql statement.

Delimit the word Password with square brackets.

sSQL = sSQL & "[Password], "