Populate a text box from a list and update a second list from the result
I have been working on this for two days and haven't been able to get a result.
We have a form with two list boxes (lstEntities and lstPrincipalHospitals and a text box (txtABNID). When the form is current, lstEntities and lstPrincipalHospitals are populated by select queries from tables REFProviderRegister and VendorDetails which have a 1 to many relationship on ProviderID.
What is required is that with the OnClick event in lstEntities, txtABNID is updated from lstEntities.Column(1) and lstPrincipalHospitals should update with the details of the hospital names where ABN = txtABNID.
Everything works when the form is current, however when the lstEntities is clicked, lstPrincipalHospitals goes blank (no data at all).
Could you please peruse the code and suggest how this might be remedied?
Verify that you indeed should be using Column 1
Note that column indexes are zero-based (ie: the count starts at zero, not 1) and generally ID fields are in column zero.