[AccessD] Adding "All" to Combo List

Via VBA code, but I supose you mean using a SQL UNION query like this

SELECT -9999 AS Product_LID, "All" AS ProductDescription FROM PROD_Main
UNION 
SELECT Product_LID, ProductDescription FROM PROD_Main;
 
Erwin


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina Norris
Fields
Sent: Monday, February 06, 2006 4:23 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Adding "All" to Combo List

Hi,

I know I saw something about how to do this discussed on this list.  How
do I add the "All" indication at the top of a combobox list?  Thanks.

Tina

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com