Database Form Query

[mogul0212]

So are you saying your going to have 8 combo's and every tool # the user selects must be used in the tool record to be shown? If so you will need to change your Or to AND in your Where Clause.

Yes, exactly.

I tried modifying this line to take out the Or and put in And it doesn't return any results even if I only use 1 search box.

    If IsNull(strWhere) = False And Len(strWhere) > 2 Then
            strWhere = " Where  ([Outside Tool #1]in (" & strWhere & ")" & "Or [Outside Tool #2]in (" & strWhere & ")  Or [Outside Tool #3] in(" & strWhere & ")  Or [Inside Tool #1]in(" & strWhere & ") Or [Inside Tool #2]in(" & strWhere & ") Or [Inside Tool #3]in(" & strWhere & ") Or [Inside Tool #4]in(" & strWhere & ") Or [Inside Tool #5]in(" & strWhere & "))"
    End If