Which is better as a form datasource: Tables or queries?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any advantage over using a table or a query as the datasource? Is
one quicketr than the other?
 
Is there any advantage over using a table or a query as the datasource? Is
one quicketr than the other?
Click to expand...

No, in terms of speed, there is no difference. From a design and developer
point of view, you will OFTEN find that using a query is a better choice.
For example, if you have a form, or even a sub form, and always want the
sort order to be set, then simply use a query. Doing so means you don't
have to worry about setting the order in the form..and you will sleep easy.
So, set the order in the query, and then base the form on that.

So, it is not a issue of speed, but one of what you are trying to do...
 
Back
Top