Logic. What is better to creat a form from? A table or a query?

  • Thread starter Thread starter David K.
  • Start date Start date
D

David K.

I've seen responses to my and other people problems and I've noticed that the
gurus will sometimes recommend creating a form based on a query.

Can someone explain why that would be more beneficial or prudent rather than
creating a form directly from a table? Or, maybe I misunderstood and it
doesn't really matter. Either way, I was hoping to have a little more light
shed on the subject.

I'm rather new at using Acess and want to start off on the right foot before
I get to far into my database.

Thanks in advance.
 
David K. said:
I've seen responses to my and other people problems and I've noticed that
the
gurus will sometimes recommend creating a form based on a query.

Can someone explain why that would be more beneficial or prudent rather
than
creating a form directly from a table? Or, maybe I misunderstood and it
doesn't really matter. Either way, I was hoping to have a little more
light
shed on the subject.

I'm rather new at using Acess and want to start off on the right foot
before
I get to far into my database.
Click to expand...


It's primarily a matter of convenience. If you really want all the records
in the table and all, or most, of the fields in the table, feel free to use
the table. Certainly there's no reason to prefer a query that is just
"SELECT * FROM TheTable;". But there's a lot you can do with queries,
especially in the way of limiting the records returned and looking up values
in other tables, so the more comfortable you get with queries, the more
likely you are to use one as the recordsource for your form.
 
Thanks everyone for all of your responses. I feel more confident about
moving forward. Take care.
 
Back
Top