I have a search that will include four drop down menus on a form. People can select one, or leave it blank to select all from each drop down menue. I then need to search the database with the criteria they specified. Which is easy except for if they don't specify critera for one of the choices, it has to return all the records for that field. Any ideas how to do this?<BR><BR>For example:<BR><BR>They can search the database of used equipment by:<BR>Manufacturer: choose one<BR>Year: choose one<BR>model: choose one<BR>Category: choose one<BR><BR>They can choose a specific parameter for any of the above four, or select "all". Then it has to pull the records that meet all of the criteria. I'm sure this isn't that hard, I'm just drawing a blank.<BR><BR>Thanks!