rvp032582
Posts: 47
|
| Posted: 05/25/2006, 1:34 PM |
|
i need to be able to have a checkbox list of housing types. if someone is looking for 1 bedroom and/or a 2bedroom, when the choose those 2 checkboxes, the results of the search need to have both property types.
maybe this is a dumb question with an easy answer, but i've tried it, by selecting more than one checkbox and no results were displayed. it only displays results when 1 checkbox is selected
anybody have an idea to get it to work?
thanks,
rvp
|
 |
 |
boris
Posts: 14
|
| Posted: 05/25/2006, 4:33 PM |
|
The way i achieved this in my app was to have checkboxes in your Search form. These were Boolean with True and False in the Checked/Unchecked Value.
On your Grid's Data Source i added a Parameter to the Where statement which states that if [Table].[Boolean Field] is equal to Checkbox Name as specified in your Search grid.
For the second checkbox just add another Paramether in the Where statement just like above but make sure it's an OR not an AND.
I'm not sure if this example would work in your particular circumstance but the method is the same. I hope i explained it well enough for you to get the idea?
|
|
|
|
|
