View Single Post
  #1  
Old April 24th, 2010, 12:14 AM posted to microsoft.public.access
PeterM
external usenet poster
 
Posts: 208
Default Faster DCount or Query

I have a listbox on a form in AC2003 that counts the total number of entries
in a table.

Select count(*) from Medication

I execute the requery of the listbox after each record save.

My question is, is it faster/more efficient to continue using the listbox or
simply do a DCount?

Thanks in advance.