Filling Combo box with values from a query & value list

Hi,

Just wondering if you can mix values in a combo box.

I want to fill it up with some query such as:
select name from tblDetails;

and that may produce a combo box with:
"John"
"Peter"
"Frank"

but I also want in that list... a string literal in it, without adding
a record row to the tblDetails.
"John"
"Peter"
"Frank"
"Blha Blah Blah"

Thanks

re: Filling Combo box with values from a query & value list

On 19 Jun 2006 18:54:22 -0700, jason.teen@gmail.com wrote:
[color=blue]
> Hi,
>
> Just wondering if you can mix values in a combo box.
>
> I want to fill it up with some query such as:
> select name from tblDetails;
>
> and that may produce a combo box with:
> "John"
> "Peter"
> "Frank"
>
> but I also want in that list... a string literal in it, without adding
> a record row to the tblDetails.
> "John"
> "Peter"
> "Frank"
> "Blha Blah Blah"
>
> Thanks[/color]

Something like:
Select tblDetails.NameField from tblDetails Union Select 'Blah Blah
Blah' from tblDetails Order by tblDetails.NameField;
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail