How to sort using radio buttons?

[PoorCadaver]

DB SAMPLE 2.0.mdb

I'm adding a sample of my db. Will you please show me how to do it, 'cause I'm completely stuck

[rpeare]

This is the code I have for your SEARCH button

Private Sub Kommandoknapp4_Click()

    If fActive1 = 1 Then
        Me!frmSearchSub.Form.RecordSource = "SELECT * FROM tblUnit"
        Me.frmSearchSub.Requery
    ElseIf fActive1 = 2 Then
        Me!frmSearchSub.Form.RecordSource = "SELECT * FROM tblUNIT WHERE IsUsed = -1"
        Me.frmSearchSub.Requery
    ElseIf fActive1 = 3 Then
        Me!frmSearchSub.Form.RecordSource = "SELECT * FROM tblUNIT WHERE IsUsed = 0"
        Me.frmSearchSub.Requery
    End If

    
End Sub

And it seems to work for me though you've got a bunch of broken references when the form first opens.

[PoorCadaver]

Yeah, but don't you get #Name? in the results?

[rpeare]

No I don't. Typically that's when you have a reference to a field that doesn't exist or a formula that can't be reconciled. Let's say you have field called firstname but you have a query that's something like firstname: left(firstname,1). Because the alias for the calculated value is the same as a field from your table in some versions of access you'll get the problem you're encountering. I recall, however that your database is pretty simple (the sample you sent) and the code I posted last worked and showed values for everything properly.