Query using multiple combobox selections 1

[kklaus]

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.

 

[PHV]

A starting point:
WHERE
(Table.Producer=comboProducer Or IsNull(comboProducer)) AND
(Table.Underwriter=comboUnderwriter Or IsNull(comboUnderwriter)) AND
(Table.Office=comboOffice Or IsNull(comboOffice)) AND
(Table.Unit=comboUnit Or IsNull(comboUnit))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[kklaus]

PVH
Thank you, Thank you, Thank you!!

That was exactly what I need and works great!!!


Kathy