Criteria linked to form combo 'Yes/No or All' expression help

Tech-Archive recommends: Speed Up your PC by fixing your registry

I have a query field linked to a form combo box, like this:

Between [Forms]![frm_Runs].[cbo_Point2Point_Getrounds_From] And
[Forms]![frm_Runs].[cbo_Point2Point_Getrounds_To] And
<[Forms]![frm_Runs].[txt_Run_Limit]

In the form combo box I have a -1 or 0 choice. I want a third choice which
is All (or in plain english 'Both'. In other words if the user chooses
All/Both in the combobox, I want the query criteria to show all records.

The format in the combobox can be any format that will get the job done, at
the moment it is plain text. I have tried a Yes/No format but it will not
allow a third state. I want to avoid a checkbox because it is not obvious to
the user that a third state exists with that control.

How can I make the query criteria return All values when the user selects
All/Both instead of either just the -1 or 0s?



.

Relevant Pages

  • Re: Queries and Dates
    ... The query criteria can be any valid date format. ... > The table field is formatted and has an input mask set up for a short date. ...
    (microsoft.public.access.queries)
  • RE: Criteria linked to form combo Yes/No or All expression help
    ... edit it for the third choice. ... I want the query criteria to show all records. ... The format in the combobox can be any format that will get the job done, ... the user that a third state exists with that control. ...
    (microsoft.public.access.queries)
  • Format query column as number
    ... I am trying to use a>6 in my query criteria but it is not working. ... suspect the problem is values in the column are not numbers. ... a way to format the column of a query to a "NUMBER"? ...
    (microsoft.public.access.queries)
  • Re: formatting a calculated number field on a form
    ... > A query in an MDB file CAN call a user-defined function. ... > function name is Age and it returns a double. ... The user will certainly "notice" if a patient was born on Jan ... I just want control over the *display format* of a number ...
    (microsoft.public.access.forms)
  • RE: Query count then average.
    ... What was happening in my database was the query returned the ... "Ken Sheridan" wrote: ... It probably depends where you set the Format property. ... "Robert F." ...
    (microsoft.public.access.queries)