Hi!
I have a sorting-question, but first the design of my db...
In my database with equipment I have a checkbox telling if the product is in use or if it's archived. The value is '-1' if it is in use and '0' if it is archived.
I use a form to list and sort out items using textboxes and drop downs. I fill out the form and hit "Search" to sort and show the equipment based on the criteria in the form. I do this using a query connected to the database.
I would like to add three radio buttons to the search form to select "all equipment", "equipment in use" or "archived equipment" when I sort. I use the wizard to create the radio buttons and give the values -1 and 0 to the two latest chioces, but what about the "all equipment" chioce!?
The form works fine with the "equipment in use" and "archived equipment" but I have to assign the "all equipment" a value. And what do I write as conditions in the query?
Right now I write...
LIKE [Forms]![frmSearch].[fActive1] & "*"
...where [fActive1] is the group of the three radio buttons.
I hope I wrote this understandable for you. If not, please ask if anything is un clear!
Thanks!