Hello,

I'm working with a database in Access2000. This is what I'm looking for.

I have one table where I have a lot of machines. These machines can produce one or more productgroups. These are defined as checkboxes (YES/NO).

When I open the database I want an easy way to choose one or more productgroups and when I press a button I want the machine form to open, showing only the records that match one or more of the productgroups selected.

I think I should use something like the code below. Not sure how I get it to match more then one product category at the time.

Code:
    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "b1"
    
    stLinkCriteria = "[a2a_packs]=" & Me![a2a_packs]
    DoCmd.OpenForm stDocName, , , stLinkCriteria