I have 2 list boxes and another form.

The first list box is lstparentcompanies, the 2nd lstchildcompanies.

When I select lstparentcompanies, lstchildcompanies is populated with all of the child companies of that parent company.

Fine that works.

When I select lstchildcompanies the form is dynamically filled with data based on the lstchildcompanies. (bit o SQL).

Fine that works.

My problem is...in the form which holds lstchildcompanies data the data stays until my selection changes in lstchildcompanies.

Normally this is fine, but the problem occurs when I change my lstparentcompanies selection.

We have a new parent companies selected. lstchildcompanies populates with all new companies...but the form stays filled with old data from the previously selected child company.

What I want to do is somehow make the child companies list box, by default, select the first value in its list. This will then force a refresh of the forms data.

So when this happens, the form is populated with that child company's info, instead of waiting for the user to select a value in the lstchildcompanies.

Is this clear enough?

And no, selectfocus does not work, because it does not highlight or select a value, it just throughs a light square around a value which I can t key off of.