Originally posted by jacque427
For some reason or other my reports/querys require exact spelling.
If I misunderstand you then I apologize, but here are two (very basic) ways you try to take care of it.
1) Use a form to transfer the value from the combobox to the query. Create a form with a combobox with your names in it, then you can create a button that will open the report or query. When you build the query you will want to use the following as the criteria:
That will pass the information from the combobox to the query. That way you won't have to worry about people using exact spellings, they can select the names from your list.
2) Use your exsisting query but make the field accept a broader range of searches. Use the following in the Criteria field:
Like "*" & [Enter the User Name] & "*"
That way it uses wild cards, and the user can just type the first 3-4 letters of a name, and it will return all the names that begin with those letters.