Option Buttons Selecting Range...

[mixedguy]

I have 4 Option buttons where I need it to filter a query based on what Option I select. Assumption, if OptionBtn 1 and OptionBtn 3 are selected then that will put the following criteria in my query >=1 And <=3. Another assumption, if OptionBtn 2 and OptionBtn 4 are selected then that will put the following criteria in my query >=2 And <=4. There can by any number of choices. How would I set this either in VB Code or using a macro?

Thanks in advance.

 

[chappy]

Are you only allowed to have two options selected at any given time?

 

[o1110010]

I have 4 Option buttons where I need it to filter a query based on what Option I select. Assumption, if OptionBtn 1 and OptionBtn 3 are selected then that will put the following criteria in my query >=1 And <=3. Another assumption, if OptionBtn 2 and OptionBtn 4 are selected then that will put the following criteria in my query >=2 And <=4. There can by any number of choices. How would I set this either in VB Code or using a macro?

Thanks in advance.

This way might be the more tedious route but it's something you can work with until someone else replies.

You should be able to do this in your query in the Criteria rows. Just add the search field a couple times with various criteria for each field. Example, OptionBtn1 = 1 AND OptionBtn2 = 1