[AccessD] Add All to List

Virginia

...use a UNION SELECT in the combo record source to add an ALL.

...example:

SELECT DISTINCTROW Customers.Company, Customers.[Customer Number] FROM
Customers UNION SELECT "<ALL>","" FROM Customers ORDER BY Customers.Company;

William Hindman "My idea of an agreeable person is a person who agrees with
me." Disraeli

----- Original Message ----- 
From: "Hollis,Virginia" <HollisVJ at pgdp.usec.com>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, March 03, 2004 8:45 AM
Subject: [AccessD] Add All to List


> How do you add All to List? This form contains 2 combo boxes on a main
form.
> Selecting data shows data on a subform for the related combo box choices.
>
> I need to either have an All in the combo boxes or when the form opens, I
> would like them to be blank.
>
>  I tried this code in the On Open of the main form, but it still opens to
> the first record with entries in both combo boxes.
>
>     With Me
>         .cboNCSANo = ""
>         .cboProcedure = ""
>     End With
>
> Virginia
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>