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