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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Combo boxes can have multiple columns but only display those you wish. Keep
your -1 and 0 but add a new choice of say three. Use the Column Widths
property to control what is dispalyed like 0"; 1.5" to show the second
column and not the first.

You only posted a part of the SQL statement so I can not advise on how to
edit it for the third choice.

"efandango" wrote:

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?



.