Hi Folks, I have a simple, unbound list box on an unbound form. It has three columns. The rowsource is set to a query to obtain the employee id, name, and department. Some employees will be in two departments, so I wanted the user to be able to distinguish, so listed the department. The bound column is the employee id.
The box was working fine, but all of a sudden, every time I click on it, it selects two values instead of one. The two values it selects are the two corresponding employee entries.
Equally frustrating, a combo box I have set to pick up values dependent on the list box is now returning ALL values for the employee, rather than just the ones for the employee and department, like it was before.
I have the on-click event of the list box set to requery the PO combo box, so when the employee changes, the data in the other box changes as well. I've also put this in the after-update event, as I wasn't sure which one would fire at the correct time.
Thank you for any help. I hope this wasn't too garbled.
It was all working just fine until it wasn't. Any ideas what is going on? I've double checked the property settings and it's still just "simple" list box (not multivalue). I've saved, closed, and reopened the form but it's still selecting two items.