Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Wed Aug 1 21:09:28 CDT 2007
That looks right Andy. I'll give it a try later. Thanks. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey Sent: Wednesday, August 01, 2007 5:38 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Empty Recordset Rocky, try If Me.Recordsetclone.recordcount=0 then.... Ought to work I think. -- Andy Lacey http://www.minstersystems.co.uk --------- Original Message -------- From: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Subject: [AccessD] Empty Recordset Date: 01/08/07 12:13 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 ________________________________________________ Message sent using UebiMiau 2.7.2 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.11.0/929 - Release Date: 7/31/2007 5:26 PM