Forms Record Source

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

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Harvard" wrote in message
...
Is it better to build a form based on the actual table or to build it on a
query instead?

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.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200802/1