DropDown Box on Form

[BDW1969]

I have a form with a dropdown box that list many different company names that can be selected to run a report. I need to know how to add an option to allow the user to select all the companies?

Thanks

 

[PHV]

What is the RowSource property of the combo ?
The classical way is to add something like UNION SELECT '*','<Select all>

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244