I am creating pretty much the same thing as Simon. I want to be able to choose 1 zip code or all zip codes in the field. The parameter: [Forms]![Open this to use query]![Zip] allows me to input 1 zip code from a combo box and I get the correct results, based on other combo boxes in the query. However, when I add: [Forms]![Open this to use query]![Zip] Or [Forms]![Open this to use query]![Zip] Is Null I get all records in the table, ignoring the selections I made in the other combo boxes. Any clue to what I am doing wrong? Thanks, Rawknee "Simon" wrote: > Hi Tom and thanks very much. It was as simple as that. It made my attempted > IIf look pretty stupid!! > > "Tom Wickerath" wrote: > > > Hi Simon, > > > > Try a criteria like this for the field that corresponds to your combo box: > > > > =[Forms]![FormName]![ComboBoxName] Or [Forms]![FormName]![ComboBoxName] Is > > Null > > > > > > To include all records, do not make a selection from the combo box. > > > > > > Tom > > > > http://www.access.qbuilt.com/html/expert_contributors.html > > http://www.access.qbuilt.com/html/search.html > > __________________________________________ > > > > > > "Simon" wrote: > > > > > I have a form which has several text and combo boxes which when completed by > > > the user provide criteria to a query. This works fine, although I need the > > > option to display all. ie instead of selecting a specific item from a combo > > > box, somehow select all as if the parameter were not there. I could do this > > > by using different queries with or without the criteria but I am sure there > > > must be a better way. I am using Access 2003 and any help would be much > > > appreciated.