[AccessD] Number of records in a form

Loads of ways, Dale

One simple way is:

If dcount("*","MyTable") = 0 then
Msgbox "OMG where have the records gone"
Else
Msgbox "Phew, here they are"
Endif

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dale Kalsow
Sent: 14 September 2009 16:02
To: Access Developers discussion and problem solving
Subject: [AccessD] Number of records in a form

Good Morning Everyone,
 
I am trying to figure out if when a form opens if there are any records in
the table that is linked to the form.  If not then I want to display a
special text box. 
 
Does anyone know how to tell if the table is empty?
 
Thanks!
 
Dale


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