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.
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!
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
