Home  Fees/Services  Access Templates  Tutorials  Tutorial Downloads  Articles  Search  Contact  Privacy  Links

Union Query: Combo Box All Choice
Access Combo Box


Updated On 7/19/2017 6:45:05 PM

Combo Box Tutorial






Combo Box Tutorials
Fill Form Field Code
Combo Box: All/Any
Dependent DropDown
Cascading Combo Box
ComboBox Multiple Items
Lookup List Best Way
Lookup Lists 1 Table
Faster Combo Boxes
Table-based Combos
Y/N Drop Down List
Dynamic List Box


Combo Box All or Any Choice

List a Default Value For Combo Box and Lookup Lists



Are you just starting out on your quest for a small business database? Need some advice or someone to bounce ideas off of? We are happy to chat with you to discuss options to your situation.

Are you looking for an MS Access template database? We have many for sale in our Access Template and Examples Software section.


Create a drop down lookup list from a table field with ' All' added to the list of values.  This example is often used for selecting specific (or All) records for a report. The Union query is used extensively in advanced query design.  This union query example is perhaps the simplest example.  Here we assume you have read our Microsoft Access database design recommendations.
Access Union Query Example

Note: Putting a space before the 'A' in All makes this lookup list choice sort to the top.

This method is also great for adding a '<<< New Item >>>' choice to the lookup list.

New! Download Access example of Combo Box Add New Choice.

Warning:  General warning about union queries -  Never try to use aggregate functions (avg, count, sum, etc.) in a union query.  It will drop out duplicate groups of records (in Access at least ).

More info on this topic:

Union Query Downloadable Example

Our Union Query Example demonstrates a method used to add additional choices to drop down lists such as New or All. Using the New choice in a combo box ...

 








A Blue Claw Database Design Article:

Repair Corrupted Access Table
 





Blue Claw Database Design Downloadable Tutorial:
TransferText & OutputTo Microsoft Access Download.  





A Blue Claw Software Design Template:

Work Order Administration Software
 

Contact Information

Copyright 2000-2017 Blue Claw Database Design