[AccessD] Empty Recordset

Rocky,

Before you actually modify the form's recordsource in code, you'll need to
open a recordset to see if rst.EOF = True

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Wednesday, August 01, 2007 6:59 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Empty Recordset

Dear List:
 
On a bound form a modifying the Recordsource with WHERE conditions might
result in no records being retrieved.  Then there are lots of things you can
do which generate errors.  Is there a way to detect this no record condition
in a bound form?
 
MTIA
 
Rocky
 


 	
	

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com