Yes, it is Row Sourece Type of 6 for Fields. I forgot to mention that the ControlSource just says "Employee".
I am not sure what you mean. Do you mean that I ahoul remove the "EMPLOYEE." from "EMPLOYEE.EMPLOYEE" which is in the ROWSOURCE property?
>Remove Employee from Employee.Employee (e.g. have only one Employee. at the beginning). I assume you're using type 6 as RowSourceType.
>>I don't normally use List Boxes but my predecessor used them extensively. I am trying to stop some strange behavior that is happening. It seems that if you click on this listbox, it will replace the 4-digit employee number with the first four characters of the employee's last name.
>>
>>I have looked for any method that might be doing this and there is none that I can see. I don't understand how this could be.
>>
>>Here's what is in the RowSource property:
left(employee.name,10)+" "+employee.employee+":"+empl_mch1.mch+":"+hlpr_mch1.mch
>>There is an EMPLOYEE table and also a HLPR_MCH (Helper Machine) table. The EMPLOYEE table is related to the HLPR_MCH table through the Employee field, which is actually the 4-digit EMPLOYEE NUMBER, a character data type field.
>>
>>I looked for a READONLY on the LISTBOX properties, but that doesn't exist, so I disabled it; but then the user can't see what is in the listbox past a certain point, unless they can scroll down. With it disabled, they can't scroll. So, I go round and round.
>>
>>I need a ListBox expert to help me with this.
>>
>>My question is this: WHY does the EMPLOYEE NUMBER get replaced with the first 4 characters of the EMPLOYEE NAME?
>>
>>Like I said, there are no METHODS, no CLICK EVENT, nothing to do this behavior, yet it happens each time you click on the LISTBOX.