I have a Query where 3 of the fields are linked to 3 combo boxes on a form. how can i get to kick off the query from the from. at the moment I set the values on the form the go back to the query and run it. I would like to be able to run it from the form.
Sometimes not all the values in boxes are set requiring all the values for that field to be retruned but at the moment if you do notset a value no rows are returned. how do I get round this.
thank you
Sometimes not all the values in boxes are set requiring all the values for that field to be retruned but at the moment if you do notset a value no rows are returned. how do I get round this.
thank you