"Adjust" a combo box's list

[Gord]

Is it possible to somehow add the option of "All" at the top of the list of
a combo's drop down list? I'm hoping I don't have to go and re-jig the
underlying table and/or query that the list is based on to get this to
appear at the top of the list and can force it to happen directly with the
combo box.

Thanks,

Gord

[paii, Ron]

Try a Union query as the combo's source, the 1st select would output "All"
then Union All your existing source for the remaining options.

"Gord" <x1******@telus.netwrote in message
news:yydwk.372$1x6.199@edtnps82...

Is it possible to somehow add the option of "All" at the top of the list

of

a combo's drop down list? I'm hoping I don't have to go and re-jig the
underlying table and/or query that the list is based on to get this to
appear at the top of the list and can force it to happen directly with the
combo box.

Thanks,

Gord

[Gord]

Thanks Ron and Fred.

Using the <to bracket 'All' will work just fine for my purposes.

Gord

[jonceramic]

On Sep 5, 1:09*pm, "Gord" <[e-mail]:

Thanks Ron and Fred.

Using the <to bracket 'All' will work just fine for my purposes.

Gord

Gord,

Here's how the fine folks of this newsgroup showed me how to do it
recently... It's got the complete "union" how-to in it...

http://groups.google.com/group/comp....e728438d99eaca

Jon