Creating forms - general ?

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

Guest

Hi all,

When designing forms, is it best to based the forms on queries or directly
with the tables?

Thanks
 
Brian said:
Hi all,

When designing forms, is it best to based the forms on queries or directly
with the tables?
Click to expand...

It's best to load as few fields and records at a time as possible. If you need
all the fields then it makes little difference as limiting the records being
loaded can be done as easily with tables as with queries.

Queries allow you to put some calculations into the RecordSource and apply a
reliable sort order. If you need or desire those then a query is better.
 
I tend to use queries, but I am far from being an expert on the subject.
Queries give you flexibility sorting the data, let you add calculated fields
(such as combining first and last names) and specify criteria (such as a date
range), allow you to combine several tables and/or queries, and in general
tend to be more versatile.
 
Back
Top