Form based on table or query

  • Thread starter Thread starter Marco Simone
  • Start date Start date
M

Marco Simone

Hi,

I have form for entering data. Is it better to link form on table or query?
I think it is usually to link form text boxes to table and not to query.
When it would be right to use query?

Thanks for help, Marco
 
Marco said:
Hi,

I have form for entering data. Is it better to link form on table or query?
I think it is usually to link form text boxes to table and not to query.
When it would be right to use query?
Click to expand...

Most of my forms are bound to queries, not tables. That might depend on
taste. I like the sorting and filtering capabilities of queries better
than the available OrderBy and Filter properties of the form, most of
the time. The query is constant in nature, and can be inspected and
edited. The form properties must be set somehow and activated with the
respective OrderByOn and FilterOn.

When the query is not updatable, it is wrong to use it as a data source
for and edit form. That much is obvious.
 
Back
Top