Bind forms to query or sql statement

[deekay]

Im trying to update a database where our users have been
entering/editing all data using queries to now use forms instead. The
first step that I want to take is to convert the queries to forms in
datasheet view so that they look exactly the same. I just want to know
whether it is better to bind the forms record source to the queries or
to a sql statement that would include the relevant tables and fields.

Please advise

thanks

[Larry Linson]

"deekay" <de*****@gmail.comwrote in message
news:11**********************@f16g2000cwb.googlegr oups.com...

Im trying to update a database where our users have been
entering/editing all data using queries to now use forms instead. The
first step that I want to take is to convert the queries to forms in
datasheet view so that they look exactly the same. I just want to know
whether it is better to bind the forms record source to the queries or
to a sql statement that would include the relevant tables and fields.

A query is simply a saved SQL statement. The Query Builder is just a visual
interface for creating SQL statements. So, there is no difference in
performance or function.

The difference would be, if you have a Query which you want to use as the
Record Source for a Form and a Report, and you will always want the same
changes in one as the other, it is more convenient to create a Query to use
as the RecordSource for both the Form and the Report. If you want the
RecordSource to be independent, and not subject to being inadvertently
changed, then using an SQL statement directly in the RecordSource or a
separate saved Query would be appropriate.

Larry Linson
Microsoft Access MVP

[tina]

another consideration is that saved queries are not protected when you
convert a frontend database to a .mde database for distribution to your
users. if you've implemented Access security, that's not an issue. but if
you have not, then using a SQL statement for each form and report
RecordSource ensures that your users cannot make changes to the
RecordSource.

hth
"deekay" <de*****@gmail.comwrote in message
news:11**********************@f16g2000cwb.googlegr oups.com...

Im trying to update a database where our users have been
entering/editing all data using queries to now use forms instead. The
first step that I want to take is to convert the queries to forms in
datasheet view so that they look exactly the same. I just want to know
whether it is better to bind the forms record source to the queries or
to a sql statement that would include the relevant tables and fields.

Please advise

thanks