Like "*" & [Forms]![Plan/ProdnApprovalSU]![Cbovariety] "*"
This criteria used in a query works most of the time. However, I have two products Hyola 500 and Hyola 50. On the form, I select Hyola 500 and only a list of Hyola 500 are selected. when I select Hyola 50, I get both Hyola 50 and Hyola 500