Why is Select statement is used as Record Source?

C

clara

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
 
F

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
Click to expand...

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.
 
C

clara

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


fredg said:
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
Click to expand...

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.
Click to expand...
 
F

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

fredg said:
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
Click to expand...

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.
Click to expand...
Click to expand...

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
 
Top