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.