Select value in list box at design-time
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.
