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:
  1. ....[ If Not CheckPass_Rs.BOF Then
  2.             CheckPass_Rs.MoveFirst
  3.             str_Password = CheckPass_Rs!Password
  4.             If Trim$(UCase$(Old_Tbox.Text)) <> str_Password Then
  5.                 MsgBox "Invalid old password"
  6.                 Old_Tbox.Text = ""
  7.                 NewPass_Tbox.Text = ""
  8.                 Verify_Tbox.Text = ""
  9.                 Old_Tbox.SetFocus
  10.             Else
  11.                 [I]oSQL[/I].Execute "UPDATE UserMaster SET Password = '" & UCase$(NewPass_Tbox.Text) & "' where User_Id = '" & UCase$(UID_Tbox.Text) & "'"
  12. Call MsgBox("You have successfully chosen a new password", vbInformation, "Password Changed")
  13.             End If
  14.         End If