multiple values for query on form

[rodrigcz]

hey there, ill get right to the point ..i have a database and on the main table one of the columns is "Status". The values in that column can be either "Worked, Unworked, or Overdue".

I would like to be able to create a form so that the user can run a query and select which Status' they want to see. For example maybe they only want to see Unworked and Overdue so they can select those and run the query.

Would anyone be able to give me some insight on how to go about this, or point in the direction of how?

Thanks,
Chris.

 

[Geotch]

Here's a sample for you. Chose a value in each of the drop down boxes, then click the button to get results.

 

[Mihail]

And here you can find more examples about filtering data in a form (see the last uploaded DB)
http://www.access-programmers.co.uk/forums/showthread.php?t=258024&goto=newpost

 

[rodrigcz]

Is it possibile to use Option buttons as a parameter for a query?

 

[Mihail]

Is it possibile to use Option buttons as a parameter for a query?

Yes.
But the option button is never a "single".
The option buttons should be, at least, two, grouped in a Option Group Frame.
Based on what button is checked, the Option Group Frame take a value that can be used anywhere:

Forms!FormName!OptionGroupFrameName.

If you take a look into the link I provided will see many options buttons "at work".