What do you mean with "it shows false when it is eof or bof"? If the recordset does not contain records, EOF is True, otherwise it's False. E.g.:
If myRecordset.EOF Then
' No records
Else
' Records
End If
Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
|