Question about combo box source

[JimAhl]

I am using a combo box to list the names of customers to be used as a selection for a report. I am using a simple query to create the data source for the combo box. I want to be able to add the word "All" to the data source, so all customers can be selected and I can't figure out how. I tried just adding "All" as the default value, but nothing shows up when I display the form.

I would welcome any other reccomendation on how to do this, if what I am trying to do won't work.

Any help would be greatly appreciated.

Thanks,
Jim

 

[namliam]

Try searching the forum. This has been tackled many times... Add all to combobox ... (159 ! Hits)

*Sigh*

 

[JimAhl]

I have searched, to no avail. Any tips on my search criterior?

 

[namliam]

Try clicking the link i provided "Add all to combobox" which is the exact frase i searched for...

Regards

 

[JimAhl]

Thanks so much. I found it, and it worked perfectly.

 

[namliam]

Nice feature isnt it?? SEARCH !

 

[JimAhl]

Sorry for being so dense!! I didn't see the link in your reply until now.

Again, thanks for the help