Paul Hartland
paul.hartland at googlemail.com
Thu Dec 24 06:09:00 CST 2009
To all, I use a lot of recordsets, and to detect they actually contain something I have always used the following: If myrecordset.bof=false and myrecordset.eof=false then do my stuff here Else msgbox "empty" End If However my project manager prefers: If not myrecordset.bof and not myrecordset.eof then do my stuff here Else msgbox "empty" End If Is there actually a prefered way, or is one quicker than the other, or is there an even better way to do this ? Thanks in advance for any comments, and a very merry christmas & happy new year to everyone. -- Paul Hartland paul.hartland at googlemail.com