Update a Query in a Drop Down

Im confused. What do u want it to do?
it requeries so that u can select the player from that specific team.

remove the me.combobox#.value="" from them to make them not blank, at the start.
The players list is not empty when i do it on my system

Try this
Code:
Private Sub Combo15_Change()
Me.Combo17.Requery
Me.Combo19.Requery
End Sub

Thats what this did!! combo 15 was your school box!
Glad you got it figured out! take care
 
Thats funny, I looked back at the old post and you did say that! I really mess that up. I think originally I put the code in for both combo boxes and that made thing diffcult.
Once again thanks.
 
Private Sub Combo15_Change()
Me.Combo17.Requery
Me.Combo19.Requery
End Sub
This is another good argument for ALWAYS naming your controls with meaningful names, right away, after creating them so that you can find what is what in your form, and not only that but can figure out (easily) what is what 2 years from now.

If you rename them BEFORE adding code to them then you will be able to put the code on the correct event name, if you rename them AFTER adding code, then you won't have the code in the correct event because combo15_click will still have the code for the combo and then the new name cboSchoolBox_click wouldn't have the code on it.
 

Users who are viewing this thread

Back
Top Bottom