[AccessD] Add All to List

Are they bound combo boxes?  Easiest way to do that is to just use a Union
Query.

Say they are currently bound to:

SELECT CustomerID
FROM tblCustomers

Changing the source of the combo to:

SELECT "ALL" AS CustomerID
FROM tblCustomers

UNION SELECT CustomerID
FROM tblCustomers

Will populate the listbox with ALL as the top option.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of
Hollis,Virginia
Sent: Wednesday, March 03, 2004 7:45 AM
To: 'accessd at databaseadvisors.com'
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