Populating a combo box using a Select Statement

[Mattine]

I have one combo box: cboEmployee that I am using to create a report.

I am using this select statement: SELECT DISTINCTROW tblTasks.EmployeeAssigned FROM tblTasks UNION SELECT "*" from tblTasks ORDER BY tbltasks.EmployeeAssigned;

Does anyone know why, in runtime, the combo box won't populate with data? I can see the data, but it doesn't stay in the combo box after I choose it.

Thank-you for your help!

 

[sko]

Just a guess but check your bound column. If I have 2 columns in my combo box and set the bound column to 3, I get the same results.