Combo Box

[veena]

Hi,

Could you tell me how to bind a column from a combo box to a particular
field when the combo box have more than one column in it.

Thanks,
Veena

 

[Marshall Barton]

Could you tell me how to bind a column from a combo box to a particular
field when the combo box have more than one column in it.

Normally, this is not a good thing to do. Only the primary
key for the combo box's Row Source table/query should be
stored. You can retrieve whatever you need from the combo's
table by using a query that Joins the two rables for a
report or whatever. By storing two related fields (i.e.
from the same record in another table), you open the door
for them to get out of sync.

If your situation requires you to do what you asked, see
Cheryl's response to Garret's question that was posted a
little while after yours.

 

[Ken Snell]

Set the BoundColumn of the combo box to the column number that contains the
value that should be stored in the table. Set the ControlSource of the combo
box to the field in the form's RecordSource that is to get the value of the
combo box.