having trouble on form_open: set value of two listboxes

[freeskier]

hello,

i have a button that opens a form and sets two list box values based on a value from a combobox in an open form. one list box's value are dependent on the others; there is a many-to-one relationship. so for example:

cboSchool on formA contains a value. i press a button, formB opens and the button runs this code setting the two list boxes to appropriate values.

DoCmd.OpenForm stDocName, , , stLinkCriteria
 
Forms!frmSchoolData.lstDistrict.Value = intDist 'set new form equal to menu value
Forms!frmSchoolData.lstSchool.Requery
Forms!frmSchoolData.lstSchool.Value = intSchool 'set new form equal to menu value
Forms!frmSchoolData.lstSchool.Requery
 

this code works and all data is displayed correctly. however, the text of lstSchool does not Requery and the text remains the same. how do i get the text to update?

[MMcCarthy]

What is the SQL statement that lstSchool is set to?

[freeskier]

What is the SQL statement that lstSchool is set to?

thanks, that got me looking at the problem in the right way.