Hi,

How can I check for recordset contents before I do a 'MyTable.MoveFirst'
for when recordset is empty?

Rich

Hi,

How can I check for recordset contents before I do a 'MyTable.MoveFirst'
for when recordset is empty?

Rich

I depends on the cursor you are using, but in general you can use the
RecordCount property and/or check for EOF 8using the EOF property).

--
Regards

Carsten Thomsen [MVP-VB]
MCSE/VB Programmer & Analyst

PLEASE post ALL replies to the newsgroup(s) so we can all benefit from the
discussion!

Hi !
assuming rst is your recordset , run this code :
if rst.eof and rst.bof then     ' true if recordset is empty

good luck !

Sent via Deja.com http://www.deja.com/
Before you buy.