Hi,
I am currently doing a database project for school. I have a form called "advflight" which has 2 list boxes, 2 text boxes and 3 combo-boxes. The problem is that when i select one value from a box to be my criteria, it accepts all the other values as nothing, therefore returning no results in my query. But i need all these fields considered in the query UNLESS no value has been selected from them. Any help with this would be appreciated
I am currently doing a database project for school. I have a form called "advflight" which has 2 list boxes, 2 text boxes and 3 combo-boxes. The problem is that when i select one value from a box to be my criteria, it accepts all the other values as nothing, therefore returning no results in my query. But i need all these fields considered in the query UNLESS no value has been selected from them. Any help with this would be appreciated