Purpose of the record source property of the form

[SunTop]

Hello Everyone
What is the purpose of the record source property of the form ?


We can define the data source for each control on the form independently from its record source. For example if we had a text box control we can define its control source even if that control source is not in the record source of the form and if we had a combo box we can define its control source and row source even if those fields are outside the record source of the form, so what is the purpose of the record source ?

[jwhite]

form RecordSource property is to specify what dataset is going to be available for viewing/editing. It can be a table name or a SQL query. More: https://msdn.microsoft.com/en-us/lib.../ff821093.aspx

Same for reports, but of course view only.

[pbaldy]

And you can not set the control source of a textbox to a field that is not included the record source. For example, if the record source is table A, you can't set the control source to a field in table B.

[SunTop]

thanks jwhite, pbaldy for your replay,

now it makes sense