Why is Select statement is used as Record Source?

[Guest]

Hi all,

Using a table as a Recourd Source of a form is straitforward, but why is
Select statement is also used as Record Sourc of a form.

Clara
thank you so much for your help

 

[fredg]

Hi all,

Using a table as a Recourd Source of a form is straitforward, but why is
Select statement is also used as Record Sourc of a form.

Clara
thank you so much for your help

Because the "Select" is actually a query.
You can use it to sort the table records however you wish, or include
calculated data in the record source, i.e. FullName:[FirstName] & " "
& [LastName], or exclude certain fields from the form.
Click on the button with the 3 dots on the Recordsource property line
to see the query.

 

[Guest]

Hi Fred,

if some controls on a form is bound to select query fields, can a user
change the underline table fields through the controls? What about a join
select query

Clara

thank you so much for your help

Hi all,

Using a table as a Recourd Source of a form is straitforward, but why is
Select statement is also used as Record Sourc of a form.

Clara
thank you so much for your help

Because the "Select" is actually a query.
You can use it to sort the table records however you wish, or include
calculated data in the record source, i.e. FullName:[FirstName] & " "
& [LastName], or exclude certain fields from the form.
Click on the button with the 3 dots on the Recordsource property line
to see the query.

 

[fredg]

Hi Fred,

if some controls on a form is bound to select query fields, can a user
change the underline table fields through the controls? What about a join
select query

Clara

thank you so much for your help

Hi all,

Using a table as a Recourd Source of a form is straitforward, but why is
Select statement is also used as Record Sourc of a form.

Clara
thank you so much for your help

Because the "Select" is actually a query.
You can use it to sort the table records however you wish, or include
calculated data in the record source, i.e. FullName:[FirstName] & " "
& [LastName], or exclude certain fields from the form.
Click on the button with the 3 dots on the Recordsource property line
to see the query.

The fact that it is a Select query recordsource in and of itself does
not prevent adding or changing data in the table.
It depends upon how many tables are joined and the specifics of the
query.

Some queries are not updateable.
See Access help:
Query + Troubleshoot queries + Select Queries + I can't update data
from a query + Data can't be updated