By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
439,978 Members | 1,373 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 439,978 IT Pros & Developers. It's quick & easy.

In an object, like combo box, what is difference between "control source" and "Row Source"

P: n/a
I've been using row source with the QBE for my list and combo
boxes..when would I use control source?
jerry
Feb 10 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
AFIK, you use control source when you want to transfer the data in your
combo box/list box to a table or to a query etc.

They are commonly used in bound text boxes used in forms where you
enter data into a table.

Feb 10 '06 #2

P: n/a
On Fri, 10 Feb 2006 08:11:18 -0600, je*********@pioneer.com wrote:
I've been using row source with the QBE for my list and combo
boxes..when would I use control source?
jerry


The RowSource fill's out the data within the combo box.
"Select Client ID, ClientName From tblClients Order By CleientName;"

The ControlSource is the field in a table that you wish to store the
value selected in the combo box, perhaps [ClientID].

The Combo Bound Column is the column that is actually stored.

Let's say you have a rowsource of client Id's in column 1 and Client
Names in column 2. You have set the column count property to 2.
The 1st column is the bound column and it is hidden (it's column width
is set to 0", so all you see is the Client Name.
The Combo box shows only Client Names when it drops down.

You select "Brown and Co". Since the 1st column is the bound column,
the ClientID is stored in the table, even though the combo box, after
selection, displays the Client name "Brown and Co".
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Feb 10 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.