adding "all" to a combo box

[andreaL]

I have been trying to add all to my combo box so I can
select one category or All for reporting purposes. I was
wondering if anyone could give me any advice.

 

[M.L. Sco Scofield]

The article at
http://support.microsoft.com/default.aspx?scid=kb;en-us;210290 shows a
couple of different ways to do this.

I personally prefer the second method that uses a UNION query.

Good luck.

Sco

 

[Dirk Goldgar]

I have been trying to add all to my combo box so I can
select one category or All for reporting purposes. I was
wondering if anyone could give me any advice.

This page has instructions:

http://www.mvps.org/access/forms/frm0043.htm