Select "All" Group Filter Control Dropdown

  • Thread starter Thread starter Guest
  • Start date Start date
You'll need a Union query. Something like:

SELECT Field1 FROM MyTable
Union
SELECT "<All>" AS Field1 From MyTable

If you use the value of the combobx in another query, you'll need to change
the criteria to something like:

IIF(Forms!MyForm!cboSelection="<All>", [TableFieldName],
Forms!MyForm!cboSelection)

What this does is say, "if you selected All, match the field name to itself,
thus returning all records. If it's not All, filter for the value selected."

HTH,
Barry

This assumes that
 
Back
Top