I need to build a query based on Option Group/Check Box input from the user. They need to be able to query by any of four different fields in the table. I've never been able to figure out how to make multiple selections from in an Option Group so my guess I must use multiple checkboxes disguised as option groups.

Any ideas? Anyone...anyone:(

Thanks Steve.

Can you post more information? You can check values in the check boxes and use Select Case statements to process the query string. What are the columns, and how do you want query the data? (Before and after).


mmcdonal

Look it up at: http://wrox.books24x7.com

What I'm attempting to do is create an easy method for my users to create one time queries. From tblPers my users will want to query on one or more fields. The fields will be cboRank, grpStatus. cboRank has 28 possibilities. Can't envision a user would need to check more than 5 from this group. grpStatus six entries with probably not more than three checks per query. My plan is to have the user click a command button that opens a form with multiple Option Groups or groups of check boxes with all of the selections for building they query.

Thanks for the assist.

Steve.

I would use a multi select list box for this and allow the user to click on one or more, or no, criteria from each list box. Or at least a list box and some check boxes. Then package the query from there. Do you need help on passing the string?

mmcdonal

Look it up at: http://wrox.books24x7.com

I don't have access to the Library, but the multi-select list box gives me a new direction. Thanks