Forms Record Source

H

Harvard

Is it better to build a form based on the actual table or to build it on a
query instead?
 
A

Allen Browne

No difference.

If you need all the fields from the table, sorted by primary key value, just
bind the form to your table.

If you need only some records, or need them sorted in another way, either
create a query, or use a SQL statement in the form's RecordSource. Either
way, it will end up as a (hidden) saved query behind the scenes.
 
L

Linq Adams via AccessMonster.com

All forms, even ones based on a single table, should be based on a query
based on the table! The query allows you to manipulate the data, from things
as simple as sorting data to creating calculated fields. The only thing you
need to remember is if you add a field to your underlying table, in order for
it to be available to forms and reports, you need to go into Design View for
the query and add the field to the query.
 
Top