View Single Post
  #3  
Old March 26th, 2010, 05:04 AM posted to microsoft.public.access.gettingstarted
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Which is better: one or several requeries?

On Thu, 25 Mar 2010 20:22:01 -0700, forest8
wrote:

Hi

I have created about 30 NotInList events in my database.

Is it better to have 30 individual requeries or 1 requery that contains all
of them?

Thank you


None.

A properly written NotInList event will automatically requery the combo box to
which it is attached, and unless you're doing something really strange, no
other query or object should be affected.

Please explain a bit more about what sounds like a really strange form!
--

John W. Vinson [MVP]