Change control(?) source of Combo Box programmatically

[kptasteve]

I have a combo box on a form cmbCombo48 that gets its data information from a query. I then use it to select and fill in text boxes. What I Would like to do is use a command button to change the source of the information data that the Combo box is using. That way I can vary the information to put in the text box. How can this be done.

Steve Marcum PT
Programmer - Physical Therapist

 

[Eupher]

Create a command button. In this example it's named "btnMyButton". Create an event procedure for the button's On Click event that looks something like this...

Private Sub btnMyButton_Click()
Dim SQLStmt As String
SQLStmt = "SELECT ... (your new query statement here)"
Me!cmbCombo48.RowSource = SQLStmt
End Sub

Ken S.

 

[Eupher]

One more thing... You might need to requery the combo box for the new rowsource to take effect, so...

Private Sub btnMyButton_Click()
Dim SQLStmt As String
SQLStmt = "SELECT ... (your new query statement here)"
Me!cmbCombo48.RowSource = SQLStmt

Me!cmbCombo48.Requery

End Sub