Filling Combo box with values from a query & value list

[jason.teen]

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

[fredg]

On 19 Jun 2006 18:54:22 -0700, ja********@gmai l.com wrote:

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

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