In a MS Access Form: When someone clicks the "active" or "inactive" radio button from a Choice Group, I want it to filter the options in a combo box. Both the Choice Group and Combo Box are in the header. From there, the user selects the parent, and it shows the details in the detail area of the form.

Right now I have the below code to occur via the On Mouse Down" event on the Choice Group.

StatusT is the Option Group.
ActiveO is option value 1 in option group.
Inactive0 is option value 2 in option group.
The field(s) in ParentInfo table are P_First_Name and P_Last_Name for the combo box. That same table is linked to the StatusT field.


Here is a link to an image where it shows what the form currently looks like: https://ibb.co/tqkWgkn

<CODE>Private Sub ViewO_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)

Dim strCriteria As String

Dim strSQL As String

Select Case Me!ViewO

    Case 1
        strCriteria = "Active"
    Case 2
        strCriteria = "Inactive"

End Select

strSQL = "Select [P_First_Name] & ' ' & [P_Last_Name] As Customer From ParentInfo Where [StatusT] like '" & strCriteria & "*');"</CODE>