Sort form using drop-down

[PoorCadaver]

I'm trying to build a sort-combo box. When I click a post in the combo box (qSort) I want my sub form to be sorted according to my selection.



I thought you could write a code like this:

Private Sub qSort_AfterUpdate()    
    If Me.qSort.Value = "ID" Then
        Me.frmRegisterList.Form.Query = qryUnitList_ID
    
    End If
           
       
    Me.Requery
    
End Sub

This didn't work and if I do like this I have to make several querys that I can load that are sorted in different ways. Aren't there a better way?

[DepricatedZero]

Try doing something like

DoCmd.SearchForRecord acDataForm, "frmName", acFirst, "[field] =" & "'" & EscapeString(Me.cboSearchString) & "'"

That will update the record that your parent form is bound to, which should also update the subform. Will that work for you?