2 Column Combo Box and Control Source

[Russ]

Hello,

In my Access 2003 form I have a 2 column combo box that is Bound to column
2. The first column are Dates the second column are Labels, both are pulled
from an SQL 2000 database. When I add column 1 (Dates) as the Control
Source the Control Source doesn't work, the combo box remains blank. Any
ideas on how I can get this to work?

Thanks.

Russ

 

[ruralguy via AccessMonster.com]

If you are going to bind a column of a ComboBox to a field then the FieldType
of the column of the RowSource must be the same as the FieldType of the Field.