requery multiple times in same form

[pyromaniac511]

I have a test form with 2 combo boxes in it. One is Brand and one is model (lets use Cisco and Linksys as the example). If brand is empty, model is empty (I like this). If I choose a brand, its models populate the model combo box (I like this). If I choose a brand and then another brand, the first brands models populate the models combo box (I do not like this). I understand I need to clear and requery but I can't seem to find the right words to google. Would one of you point me in right direction



Here is what I have so far.

Private Sub cboBrands_AfterUpdate()
    
End Sub
Private Sub cboModels_AfterUpdate()
    Me.Query "qryModels_From_Brands"
    Me.cboBrands = ""
End Sub

Thanks.

[pyromaniac511]

I moved my SQL from its own query into the VBA and followed an example of another post. This is what I got. Please let me know if this is the right way to do it. The results seem appropriate.

Private Sub cboBrands_AfterUpdate()
    Dim BrandsSource As String
    BrandsSource = "SELECT [Models].[Model_ID]," & _
                    " [Models].[Model_Name]," & _
                    " [Models].[Brand_ID] " & _
                    "FROM Models " & _
                    "WHERE [Brand_ID] = " & Me.cboBrands.Value
    Me.cboModels.RowSource = BrandsSource
    Me.cboModels.Requery
End Sub
Private Sub cboModels_AfterUpdate()
   
End Sub

[RuralGuy]

I'm pretty sure all you need do is Requery the cboModel control in the AfterUpdate event of the cboBrand control. ie: Me.cboModels.Requery. The RecordSource can remain static and it should still work as you would expect as long as you do the Requery.