"All" and Combo Box

[Jenn]

I am still confused on how to allow a user to select all available options
from a combobox. Lets say I have 4 items in a table:

Dog
Cat
Bird
Elephant

I have created a combo box that is used as a criteria to run a query based
on what is selected (i.e., the user selects "Dog" and only the dog records
show in the query). How can I get the criteria box in the query to allow all
records to show?? I would like the list in the combo box to look like this:
Dog
Cat
Bird
Elephant
(All)
If the user selects (All) I just want the query to run without anything in
the criteria row. Is there anyway to do this. I am confused about how a
query would need to see this.

Thanks in advance!

 

[SirPoonga]

I don't have the link off hand, I'm sure one here will chime in with
the exact link, but there is an article on this at
http://www.mvps.ord/access I believe.

 

[SirPoonga]

Better yet, do a search of this newsgroup, this has been asked many
times.

 

[Fred Boer]

Dear Jenn:


Try this link:

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

HTH
Fred Boer

 

[SirPoonga]

See, I told you someone would take the time and link to the exact
article