Option Button does not work right

[ITVader]

Excellent!!! Thank you very much for the extra tip!!! Will play around with it :-D

davegri's code should work, but for clarity, with 2 criteria, you have 4 options.

I would add a button because if only the country is entered, using the "optABS" click event to apply the filter, the filter for country would never be applied.

This is for a button named "btnFilterMe":

Private Sub btnFilterMe_Click()
    'neither filter selected
    If Len(Trim(Me.Country)) = 0 And Me.optABS = False Then
        Me.Filter = vbNullString
        Me.FilterOn = False
    End If

    'Only ABS
    If Len(Trim(Me.Country)) = 0 And Me.optABS = True Then
        Me.Filter = [Main_Certification] = " & "    'ABS'"
        Me.FilterOn = True
    End If

    'Only Country
    If Len(Trim(Me.Country)) > 0 And Me.optABS = False Then
        Me.Filter = "[Country] Like '*" & [txtCountry] & "*'"
        Me.FilterOn = True
    End If

    'Both Country AND ABS
    If Len(Trim(Me.Country)) > 0 And Me.optABS = True Then
        Me.Filter = "[Country] Like '*" & [txtCountry] & "*'" & " AND [Main_Certification] = " & "'ABS'"
        Me.FilterOn = True
    End If

End Sub

[ITVader]

So the right thing to do would be to create two or three tables and make relationships between them ?

No issue with the suggestions, but this looks like the country field has one or more Nulls ('**') which is why it will work anyway. It just won't be accurate. It also suggests that the data is not normalized, like country is a field in a table where it should not be. In fact, after reviewing the image, it looks like there is only one table supporting all of these likely unrelated fields.

[davegri]

I will take one line from the code above to ask: what is the difference between

If you put a 'debug.print me.filter' after each one in the code, you will see that both produce the same string.

[ITVader]

So basically there's no difference... The code you wrote reminds me of some Java coding to join two strings, if I remember well...

If you put a 'debug.print me.filter' after each one in the code, you will see that both produce the same string.