I have a combo box that I have set up that contains a list of things. I want to tell the query that when the combo box is blank, to pull all of the records (essentially leaving my criteria blank in the query). I can't get it to work. I can get the query to run properly based on the ONE selection in the combo box but I can't get it to recognize that if the combo box is blank, to pull all records. In general, I'm using an if-then statement like this:
iif(form_combobox = null," ",form_combobox)
or
iif(form_combobox = " "," ", form_combobox)
Any suggestions? I don't know Sequel and I am running Access 2002.
Thanks!