I am having a problem getting the code i need in the criteria section of a query. The query is looking at a table that has 2 columns the second one being a partID (1,2,3,etc.) The PartID combo box is looking at the query and when a Specie is selected i only want certain ones to show up. For Example, if we select lets say Maple in the Specie combo box i want it to select all the records with 2(Maple) in the PartID, which is all of our maple parts.(1-Cherry and so-on)