Is a table or query better basis for forms

[tagteam]

If i plan to have a form with most of the data from a table and maybe add a subform is it better to just base the form off of the table to to create a query and base the form on the query?
Thanks

[pbaldy]

Many will say that forms should be based on queries, so that's probably the conventional wisdom. That said, I normally base forms directly on tables, but I almost always open the form filtered so it's not trying to pull the entire table over, using this method:

BaldyWeb wherecondition

With that method, forms based on tables with millions of records still open instantly because they're only bringing the required records back.

[ssanfu]

I base my forms on saved queries because I can have the form open with a sorted record set.
I can still open the form filtered as Paul said, but the records will be sorted.

[June7]

Alternative to using saved query object as the RecordSource is an SQL statement in the RecordSource property. The SQL statement can include sort criteria.

Then there are the Filter and SortBy properties of the form that can be used to manage these aspects of the dataset (table or query or SQL).