ms access - How can i filter a combobox selection list based on another combobox selection

Question

I'm sure this question may have been asked to death, but I cant find any answer that i can get to work. Basically I would like to have two combobox controls. One box selects an armor type for example. The next box would show only those unit types that have the armor type selected. I'm complete crap when it comes to SQl and very limited with my VBA, but would prefer a response in VBA since I understand it better. Any help in this matter would be great. please and thank you

Answer 1

There are many ways to achieve this.

For example: In the first combo box implement an Event "On Change". Do some VBA coding in it to fill up the second combo box based on the value selected on the first combo box. See a VBA example below

There are tons of tutorials if you google for "access combo box based on another".

Private Sub Combo1_Change()

    If Me.Combo1.Value = "value1" Then
        Me.Combo2.RowSource = "val 1 based on 1;value 2 based on 1"
    End If

    If Me.Combo1.Value = "value2" Then
        Me.Combo2.RowSource = "val 1 based on 2;value 2 based on 2"
    End If
End Sub