Andy Lacey
andy at minstersystems.co.uk
Wed Aug 1 07:38:00 CDT 2007
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