View Single Post
  #1 (permalink)  
Old June 13th, 2005, 03:58 AM
derniel derniel is offline
Registered User
 
Join Date: Jun 2005
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Run Time Error '91'

Hi,

I'm new in database programming with VB. My SQL table has 3 columns. When I update the content of a cell that meets a criteria, I get the Run Time Error '91', Object Variable or With Block Variable Not Set for the Adodc1 line.

My Code is as follows:

Private Sub CmdUpdate_Click()
     Text1.Text = "5"
     Adodc1.Recordset.Fields("line_no") = Text1.Text
End Sub

Thanks a lot for the help.
Reply With Quote