The difference between Record source, control source, and row source?

[longmatch]

The three data sources confused me a lot. Anybody could tell me the difference between them. How can I use them to refer my data?

Haijun

 

[jebry]

Hi Haijun!

A record source in the table or query that supplies the records to a form or report. A control source is the field that will display in a text box or combo box and is the field that Access will store information from a text box combo box or list box. A row source is the table, query or list that is displayed by a list box or by a combo box when the dropdown arrow is clicked.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[longmatch]

If I use record source to identify a data source for a form, I can use control source by selecting the dropdown list, which comes from the record source. If there are listbox or combox in the same form, I will have to have different data source using row source. Is that correct?
What is bound or unbound control? How to use them? I have real hard time to understand that.

HAIJUN