Does it bring up ANY records? If so, which ones is it not bringing up? You said, "But it does not bring in all of the Sonora's." Then it is finding something.
May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us --- On Wed, 12/3/08, luvmymelody <[EMAIL PROTECTED]> wrote: From: luvmymelody <[EMAIL PROTECTED]> Subject: [ms_access] form reference for wildcard parameter question To: [email protected] Date: Wednesday, December 3, 2008, 3:25 PM 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 [Non-text portions of this message have been removed]
