I having difficulty trying to get a parameter criteria to work with a wildcard. I have a combo box on a form that I use for the criteria. I have the combo box source of a table. I want to select from the drop down for example Sonora. But in the query there are Sonora East and Sonora Central. How can I use the wildcard to get all of the Sonora's? I am using right now LIKE '*" & [FORMS]![MIRPrompt]![MIRPrompt] & "*'" and yes the form somehow ended up with the field and the form with the same name. But it does not bring in all of the Sonora's. Any help will do. Thanks
Jim Wagner
