Query Builder vs. Using a Table Source

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all, I am learning Access, and part of how I learn things is to
re-construct.

Well, that database I am messing with now has a pull-down mneu on one of the
forms. When i looked closer it was using a query builder for the options of
the pull-down menu. I have only used a Table in the past for a pull down menu.

So, I guess my question is, which method is better?

Thanks in advance,
Scott
 
Dear Scuda:

In those cases whan using a Table is sufficient, well, it's as good as
you're going to get.

Using a query as the RecordSource is often essential for a large number of
reasons. A query will do the job any time when a Table would suffice, but
not the other way around.

I recommend you use Tables if that's more comfortable, but only as long as
it meets your needs. When you want to draw together columns from more than
1 table, or perform calculations or manipulations of the data, you will need
a query.

Updatability is another consideration. A query may not be updatable. A
table will always be updatable.

Tom Ellison
 
Using a query allows you to filter the records that appear and allows you to
specify a sort order.

Using a table does neither.

I almost always use a query since I almost always want to specify the sort order
and frequently want to limit the data that appears in the combobox.
 
Back
Top