[AccessD] Empty Recordset

Hi Rocky,
You could use a dcount("*","tableOrqueryetc","Your Where condition") before
doing anything else.
Max Sherman
 

-----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 12:59 PM
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