[AccessD] Empty Recordset

Dan Waters dwaters at usinternet.com
Wed Aug 1 07:36:47 CDT 2007


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


-----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?


AccessD mailing list
AccessD at databaseadvisors.com
Website: http://www.databaseadvisors.com

More information about the AccessD mailing list