Query with Combo boxes as criteria

[awarmplace]

I have a form that has two combo boxes. I would like for a user to be able to select both or one of the combo boxes to run a query.

 

[dhookom]

Is the query the record source for a form or report?
Is the query an action or select query?
Can the user select no values from both combo boxes?
How far have you gotten with this?

Duane MS Access MVP

 

[awarmplace]

Hi Duane,
I am using the form to pass criteria to a query. I would like for the user to be able to select one or both drop down boxes.
Example: Combo1 = Locations, Combo2 = Edit types.......
As it is right now if a user picks a location and not an Edit the Query returns nothing, they have to choose location and edit. I would like for them to have the option not to choose an Edit and it populate with all edits.

 

[PHV]

What is your actual SQL code ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886