using check instead of combo boxes

[phil009]

Hi everybody. I have a small problem. I currently am using combo boxes on my form so the user can just pick one or a range of vlaues. (Such as you could pick 1996 or 1996-2004 but not 1996,1998, and 1999). I was thinking that it might be more practical to use check boxes so the user could simply pick however many choices they want and the form would just run my query that i have going right now to generate the results. If anyone knows how to do this it would be greatly appreciated.

Thanks,
Phil

 

[TheAceMan1]

How are ya phil009 . . . .

I can't see accounting for all the many different (single)years with CheckBoxes.

If ya make one ComboBox [blue]Starting Date[/blue], and the other [blue]Ending Date[/blue] (a selection is not required for Ending Date), I don't see the problem. Besides you could include a great many (single select) years in each. Your not gonna beat this for efficiency & ease of use!

See Ya! . . . . . .

 

[sillysod]

a multiple select list box might be more practical

 

[TheAceMan1]

sillysod . . . . .

My suggestion was prompted by the fact the two comboboxes are already there, and users are use to to seeing Start & End entries. Even with that, I've stood and watched users screw up the selections. Unless their technically inclined users I would't know what to expect with multiple select (in this manner). Have you ever whatched users step thru an interface? I know people who could make alot of money testing software. Mannnnnnnnnn . . . . its incredible what they can do!

Personally, I agree with ya. I would use multiselect. After all, its easy enough to extract min/max dates.

See Ya! . . . . . .

 

[phil009]

Thanks for all your help guys. I used a multiple select list box like both of you suggested and my users are already saying that they like it better.

Thanks again,
Phil