Adam Ehrenworth
asked on
Access Form Combo Box based on Query - Add manual "All choice"
I have a combo box that is getting populated by a query
SELECT DISTINCT RAMP2015.RAMP2015Company AS Company FROM RAMP2015 WHERE (((RAMP2015.RAMP2015Compan y) Is Not Null)) ORDER BY RAMP2015.[RAMP2015Company] ;
I want to add a manual option for "All" to the list in the dropdown... can this be done in the Properties or does it need to be done in the SQL?
SELECT DISTINCT RAMP2015.RAMP2015Company AS Company FROM RAMP2015 WHERE (((RAMP2015.RAMP2015Compan
I want to add a manual option for "All" to the list in the dropdown... can this be done in the Properties or does it need to be done in the SQL?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window
and here is a screen shot of the drop-down on the main menu:
Note that I consider not making a selection equivalent to selecting ALL.
The CustomerID is fed from the AfterUpdate event of the combo box.
The code and screen shot are from my Access Archon article on emailing order lists to customers:
http://www.helenfeddema.com/Files/accarch240.zip