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
