Dropdown All Records Selection Will Not Pull All Records.

[jfs3647]

I need help with a report query function. I have a drop down control that has 3 values, Open, Closed, & Both. I am having difficulty with getting the query to pull all Open or Closed records when the dropdown choice is Both. It will display Open or Closed but not all records how would I write this?

[June7]

How are you opening filtered report? Are you using dynamic parameterized query as report RecordSource? Post the query SQL statement for analysis. If you are using VBA to build filter criteria, post code.

[HiTechCoach]

The key is to have the option Both evaluate the where clause to be

{MyStatusField] Like "*"

Your combo box with the three values, Open, Closed, & Both needs to have two columns. The bound column will return "*", "Open", or "Closed"

If using a form reference Your query would look something like this:

{MyStatusField] Like forms!MyFormName.cboMyStatusControlName

The combo box properties are:

Column Count: 2
Column Widths: 0";1"
Bound Column: 1
Row Source Type: Value List
Row Source: "Open";"Open";"Closed";"Closed";"*";"Both"