Combo box - bound column problem (access 2002)

[Kirstie Adam]

All,

I have a combo box which looks up values in a table. It has three columns
[ID], [ProductNo.], [CreationDate]. [ID] is hidden, column 1, and you don't
see it. The bound column is 3, [CreationDate]
I want the use to be able to search by [ProductNo] , in ascending order, and
have the field remember the relative [CreationDate]. But no matter what i do
it won't accept the date, it remembers the [ID] instead.

I don't understand this, as i have bound the field to column 3, not 1.

Can anyone help?

Kirstie

 

[Chris]

There are three properties of interest here. "Bound
Column", "Row Source" and "Control Source"

"Row Source" is what fills the combo.
"Bound Column" is the column that will be stored on Save.
"Control Source" is the field in the table that the "Bound
Column" will be saved to.

It sounds as if either your "Control source" is not set
correctly, or there is some custom code getting in the way.