error "91"

hi i am sanjay i created a database name "stud" and a table "fee" in it.

table "fee"

attributes: first second third
values: 200 250 300
now i set connection string for "stud" and recordset for "fee" which is ok.

i created a form name"form1" . i took a "label1" in it and a "adodc1" control. i wrote coding on form load event as:

Private Sub Form_Load()
Dim x
x = Adodc1.Recordset.Fields("second").Value
Print x
End Sub
I thought it will print value 250 on the form1 at the time of its loading but i got en error "object variable or with block variable not set" error "91"

so please help me
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!