Full Version: Add an "All" option to a combo box
UtterAccess Forums > Microsoft® Access > Access Forms
SF_IN
Hello, I was wondering how one would add an "All" option to a combo box that is pulling it's fields from a table.
For instance, I have a form with an unbound combo box. I have the combo box's record source querying the County Table and returning all of the Counties. By default when you load the form, the combo box is blank. When you click on the combo box, it drops down and you casn select the county you wish.
If I want to add "All" to the options and make it the default option. I realize I could just put a new county in there called "All", but that is not the solution. How would I go about adding an "All" option?
AQM_UK
here you go
im
SF_IN
Perfect, thank you.
AQM_UK
you are welcome
im
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.