I have a form that contains two listboxes-one contains a list of employees in a particular office and the other contains a list of the software installed on any given users computer. Theory being click on a user, see what software they have.

The first listbox's (lstLVEmployee) record source is a local view based on office location. The second listbox's (lstLVSoftware) record source is a local view based on the primary key of the Employee view.
In the InteractiveChange event of lstLVEmployee, I requery lvSoftware as follows:

=REQUERY('lvSoftware')
This.Parent.Refresh()

The corresponding view updates fine however my problem is that when I select a employee further down the list, the preceding employee’s name background becomes greyed out and nothing appears in lstLVSoftware until it receives focus. The form works fine with one list box and some textboxes but seems to go nuts when I add the second listbox. What is going on?

Should I maybe rely on code to populate the software listbox rather than update the local view the way I am doing it currently?

Thanks for any help