Setting control source to a combo box

[Ksel]

Hi all,

I have a combo box control in my form named PayDateID, but I told that control to DISPLAY the associated field PayDate.

I now am trying to make a separate control in the same form whose control source is the DISPLAYED PayDate, but it only wants to reference the underlying PayDateID.

How can I make the control source be the displayed value in that combo box?

Much thanks,
Kevin

 

[GohDiamond]

Stop naming your comboboxes the same name as the fields in your record source. Name combo boxes with a prefix like cbo_PayDateID or cbo_PayDate making the control source the field that you want the selection to be saved in. The Row Source can be any Table/Query, Value List, or Field List that you assign to be the selections of the combobox.

Now, why are you trying to display the same data twice on the same Form in 2 different fields/comboboxes?

Goh