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

Oh William
Sheer Genius
many thanks

----- Original Message ----- 
From: "William Hindman" <wdhindman at bellsouth.net>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Friday, January 16, 2004 5:18 PM
Subject: Re: [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
> >
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com