Thread: Adding ALL Button to Combo Box

Hey guys I have a problem that's been giving me trouble for a couple days now. I have a search form with several combo boxes and buttons to generate reports. The values of the combo boxes feed into the query criteria then the report generates records based on these criteria.

All but one of the combo boxes are based on values I type in. The other is based on a table named tblCampaigns that has only one field: CampaignName. What I would like to do is get this combo box to have an ALL option that brings up records based on every campaign name. Here's my current row source:

SELECT tblCampaigns.CampaignName
FROM tblCampaigns;

Thanks in advance!

Thanks man, that works great!

Just one thing though,

This works when the value for the combobox is blank. Is there anyway to make the blank value say "ALL" without adding another column? Alternatively, is there any way to make the blank an option? As of right now it's just the default value and then when you click another campaign you can't get back to it.