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.
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "b1"
stLinkCriteria = "[a2a_packs]=" & Me![a2a_packs]
DoCmd.OpenForm stDocName, , , stLinkCriteria