Using check boxes to filter

Bob Bedell · January 25th, 2006, 06:31 PM

Who put that "their" there!?!

Should be "there".

There!!:)

Bob

Bob Bedell · January 25th, 2006, 06:40 PM

Code:

' Check boxes for criteria defined as
    ' not mutually exclusive - dir
    ' See if any checkboxes are checked.
    Set col = New Collection
    For Each m_ctl In Me.Controls
        With m_ctl
            If .ControlType = acCheckBox Then
                If Me.Check171.Value = True The
                    col.Add m_ctl
                End If
            End If
        End With
    Next m_ctl

This won't work. You need the m_ctl variable. This is saying:

If control(x) is a checkbox, and Check171 is checked, add checkbox(x) to the collection, whether or not its checked. If Check171 isn't checked, don't add any checkboxes to the collection, including Check171.

Bob

Bob Bedell · January 25th, 2006, 06:58 PM

Just wanted to stress all this is is a SQL string building app. So pay real close attention to your strSQL variable. Debug.Print it, paste is into notepad to look at it, open a query in design view if you want, paste it into the SQL view pane and run it, etc. Just make modifications until the app spits out a valid SQL string that you can run in as a regular saved QueryDef. Then your good to go to run it from code.

Bob

dstein4d · January 25th, 2006, 07:50 PM

I made those changes and now I'm back to run-time error'2101'

setting you entered isn't valid for this property

    ' Assign strFilter to Form's RecordSourece property.
    Me.RecordSource = strFilter
    Me.Requery

End Sub

The way I ran this before I tried using this code was I had it run a query than post the results into another form and a subform. I created a second subform to display items from another table based on the results of my query. This way I could see the whole list of my results in subform 1 and in subform 2 display items(which are images) that are hyperlinked to open the image associated with the each individual record. So I guess what I need is to know how to structure this so I end up at with a results form so I can access those images.

Does that make sense?

Anyways have a good time fishing!!

-Dale