By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,649 Members | 696 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,649 IT Pros & Developers. It's quick & easy.

"Adjust" a combo box's list

P: n/a
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
Sep 5 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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


Sep 5 '08 #2

P: n/a
Thanks Ron and Fred.

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

Gord
Sep 5 '08 #3

P: n/a
On Sep 5, 1:09*pm, "Gord" <x1gor...@telus.netwrote:
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
Sep 5 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.