Form based on table or query

[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

 

[Bas Cost Budde]

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?

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.