I need help writing a query using multiple combobox selections. I've done this successfully for one combobox. The part I'm having a problem with is having the query "ignore" comboboxes where the user doesn't make a selection and leaves it blank.
For Example:
I have 4 comboboxes on a form: Underwriter, Office, Unit, and Producer.
If the user selects Producer and Underwriter and does not make a selection for Office and Unit, I want the query to lookup all records that have that Producer AND Underwriter.
I'm thinking I should be using a conditional statement like If Producer <> Null, but I'm not sure how to do this.