Record Souce of a FORM

[David]

Helllo all,
Very quick question....

I am building a form with a sub form. Should I build my
parent form off of my query (which selects all records
from table1) or build my form with a record source table1?

David

 

[Allen Browne]

Either way, David

You need to use a query if you wish to select only some fields, limit it to
only some records, or specify a sort order.

If you don't use a query, Access will probably create a hidden query for
you, show all fields, and sort them by primary key.