List box or subform??

  • Thread starter Thread starter Chuck
  • Start date Start date
C

Chuck

I have a form in which I need to display the results of a query. The query
itself contains three tables with joins.

Should I be getting the same performance from displaying the query results
in a list box or subform? The reason I ask is that the subform displays the
results in about 5 seconds. The list box takes about 15 seconds to display.

Is this normal ? how can I improve the spped if I use a list box (which is
the contrl I would prefer to use) ?

Thanks
 
populating a listbox using a function is the last control that populates
information. I am not sure why but it is the standard. It takes longer and I
have found no solution. Its the nature of the beast.
 
Back
Top