no current record

Hi all

When I open the form that has information in the database , there is no problems at all, but when I open the form with empty database this is the message I get. no current record.

Any one can help me to handl this problem please.

I will be highly appreciated.

Thank you

Mohammed

While displaying the records use EOF and BOf properties of the recordset.

Or use this :

VB Code:

rst.MoveLast
 
rst.MoveFirst
 
If rst.Recordcount = 0 them Msgbox "No Records in table !!!"

to use the EOF...

VB Code:

' Before opening your form (perhaps on Form Load)...
if rst.eof then
 msgbox "No records found!"
 ' Close the form or whatever
else
 'Open the form
End if

Won't VB Crash with a MsgBox in the Form Load event?

It's always a good idea to check if the state of the recordset is opened before trying to move the cursor or do whatever with it.

Explain "check the state", Need a Life Member...

VB Code:

If rst.State = adStateOpen Then
    'Work with the recordset
End If

Quote:

---

Won't VB Crash with a MsgBox in the Form Load event?

---

no...it won't crash.

Sorry I was thinking of an unload event when loading the form. Sorry...