[AccessD] A2K: Is it possible....?

Darren

...off the top of my head (and thus not tested) try Me.cboMycombo.rowsource
= "SELECT DISTINCTROW tblMyTable.* UNION SELECT "<None of the Items in this
List>" ,"" FROM tblMyTable ;"

William Hindman
<http://www.freestateproject.org> - Next Year In The Free State!


----- Original Message ----- 
From: "Darren DICK" <d.dick at uws.edu.au>
To: "AccessD List" <AccessD at databaseadvisors.com>
Sent: Friday, January 16, 2004 12:18 AM
Subject: [AccessD] A2K: Is it possible....?


> Hello all
> I have a combo box fed by a simple SQL
> Me.cboMycombo.rowsource = "SELECT tblMyTable.* FROM tblMyTable;"
> So far so good. If there are 5 items in tblMyTable I expect to see 5 items
in the combo box.
>
> Here's the tricky Bit.
> Say I want to add a 6th entry that is really just a line of text that is
not in the table
> A string something like "<None of the Items in this List>" then have the
'real' 5 or so items
> from the table in addition to the 1 line of text
>
> Make sense?
>
> Many thanks in advance
>
> Darren
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>