Yep, BoundColumn was set to 1. Yes, the EMPLOYEE # field is 4 characters. I don't know how they've had this form this way for so many years and no one ever complained about it not working properly until today. I removed the ControlSource="EMPLOYEE" and also removed the "EMPLOYEE." from the ROWSOURCE property. The form and the listbox now appear to be working properly.
Cecil
>>The ControlSource says EMPLOYEE, so I am assuming that it is the EMPLOYEE number field and not just a named ControlSource.
>>
>That's why you're getting the results you mention. Unless you set BoundColumn to something other than 1, the ControlSource gets assigned the value of the first column in the list. You have the last name there. I'll guess that the Employee field is 4 characters?
>Tamar