[AccessD] Re: Add All to List

Virginia,


Saved Query with the following as a recordsource

SELECT 0 as RecordID, "All" as SelectionOption FROM AnyTable
UNION ALL
Select YourColumnName, YourDescriptionColumn FROM YourTableName

Robert

At 08:09 AM 3/3/2004 -0600, you wrote:
>Date: Wed, 03 Mar 2004 07:45:16 -0600
>From: "Hollis,Virginia" <HollisVJ at pgdp.usec.com>
>Subject: [AccessD] Add All to List
>To: "'accessd at databaseadvisors.com'" <accessd at databaseadvisors.com>
>Message-ID:
>         <618EB4D6DDCDD3119B0A00508B6FD37A0CB0D21D at cntexchange.pgdp.usec.com>
>Content-Type: text/plain; charset=iso-8859-1
>
>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
>