User defined query??

[slyvsspy]

How would I go about setting up a form with different option buttons that define a query. Say we have a table with a list of democrat voters and republican voters and a user wants just the republican voters. The user presses the option button on the form for republican voters but not for democrat voters. How do I get the query to read it??

can anyone point me in the right direction??

thanks, Josh

 

[David R]

Are they stored as an option group in the table as well?

Option Groups commonly assign a number to each 'option'. If they have matching options in the search form and on the table, you can search for recordswhere the criteria for [TableName].[OptionParty] is Forms!PopupFormName.OptionParty

Use the Build option in the Criteria field to specify the right form, if you get confused. You can select down to the proper form and field.