Hi Tom, I have a similar problem that I hope you can help me with. I also have a "look-up" form that when my "Preview Report" command button is clicked, opens a report that is based on a query where the look-up text box is the criteria in the query. My problem is that the field is for a region number comprised of the region, district, and division (ex: Region 29, District 44, Division 00 looks like "2944-00". I want to be able to have users just type the region and district portion in the look up field, but get all divisions. When using the query to do this, I would have used Like "*2944" to get all divisions, but now that I'm using my lookup form, the only way it returns any data to my report is if the user enters 2944-00, 2944-01, etc. I've tried putting "Like "*" before [Forms]![FormName]![TextboxName] followed by another ", but it doesn't work. Can you help? Thank you so much!! "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.