Explain pls

[cmaknp]

Hi Frens

i m getting message from record count properties, anyone wud like to explain about this, i mean..why this messages is coming..& what is the solution of that.

Private Sub Form_Load()
Label8.Caption = "Record No." & " " & Data1.Recordset.RecordCount
End Sub

So i m getting messages below

Runtim Error 91
<Object variable or with block variable not set>

please tell guide me.

cmaknp

 

[johnwm]

If you are showing this code in Form Load, where have you declared and initialised your recordset?
You need to do that before the properties are available. Let me know if this helps
________________________________________________________________
If you are worried about how to post, please check out FAQ222-2244 first

'There are 10 kinds of people in the world: those who understand binary, and those who don't.'