no current record

[vbnt]

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

[veryjonny]

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

[James Stanich]

Or use this :

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

[KenX]

to use the EOF...

' 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

[James Stanich]

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

[Mc Brain]

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.

[James Stanich]

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

[Mc Brain]

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

[KenX]

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

no...it won't crash.

[James Stanich]

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