Control source vs Row source

[Boon]

Hi,

I have been working on form for quite a while but haven't completely
understood the differences between Control Source and Row Source in property
sheet of each Controls(Combo, List,...)

Would you mind explain the differences and its effect?

Thanks a bunch.

 

[Dirk Goldgar]

Hi,

I have been working on form for quite a while but haven't completely
understood the differences between Control Source and Row Source in
property sheet of each Controls(Combo, List,...)

Would you mind explain the differences and its effect?

RecordSource (applies to forms): The table, stored query, or SQL statement
that provides records for a form to display.

RowSource (applies to combo boxes and list boxes): The table, stored query,
SQL statement, or value list that provides records for the control to
display in its list.

ControlSource (applies to all "bindable" controls): The field in the form's
recordset, or the expression, to which the control is bound. If the
ControlSource is blank, the control is said to be "unbound". If the
ControlSource is an expression (beginning with an equals sign), the control
is said to be "calculated", and the value cannot be changed directly. If
the ControlSource is the name of a field, then the control's display
normally shows the value of that field, and changes to the value of the
control also change the value of that field in the form's current record.