Filter record based on multi-selection of combo box and text boxes

[joycesolomon]

Hi,

Need some help/directions/suggestions as to how i can accomplish the below:

I have 4 comboboxes and two text boxes...the text boxes will need to carry dates...start date and end date

I want to be able to filter records based on different probability

eg.
1.combobox1 with value and just a start date ---> records to show
2.combobox1, combobox2, start date ---> records to show
3.combobox1, combobox2, start date and end date ---> records to show

I somehow managed with coming out with solutions with the 4 combobox to work, in my query for each one of them, in the "criteria" area i put [Form}![frmSearch]![Combobox1]! or [Form}![frmSearch]![Combobox1]! is null and then the sql was genenrated....they work, but they dont seems to do well with the same way for the text boxes...i am not sure how to make it work...
Can someone suggest a way for this?

Thank you

 

[dhookom]

Share the best SQL view that you have as well as the control names and data types.

Duane
Hook'D on Access
MS Access MVP