[AccessD] SPAM-LOW: Number of records in a form

The dao recordset behind the form will have .BOF and .EOF true simultaneously.  Likewise the 
recordcount property will be 0.

IMO you should create a function that dimensions a DAO recordset, set that rst = me.recordsetclone 
and then perform those tests against the recordset.

John W. Colby
www.ColbyConsulting.com


Dale Kalsow wrote:
> 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
> 
> 
>