creating form with option button

[nishant.dhruve]

Hi ,
i m looking forward to create a from where i have kept several option button. now i want to create form in such a way that when i hit next button its should filter data in my table according to active option button.
Can someone suggest VBA code for it?/

[ranman256]

bad thing, Option buttons MAY need vb code.
IF you want to filter data on a numeric value , then option buttons will work.
If NOT, then you must create code to make it do string values. Which is why combo box would work better.

On the form, the options are put into a FRAME. The Frame gets the value of the option chosen. Then the query would look at this to pull data.
select * from table where [field] = forms!myForm!Frame1

[nishant.dhruve]

But how to create that Frame i m not much familiar with access and trying to learn it

[ranman256]

The frame is in the control list next to combo boxes,and list boxes.
just hover the cursor over the icon that looks like a box. The name will appear.