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

Extra value in combobox list

P: 8
Hi,

I'm wondering if it's possible "manually" add an extra value to a combobox list.

At the moment I have two fields, one "transparent" is a checkbox that lets you define a colour as transparent, and the other is a combobox called "Colours" that lists colours.
The values in Colours depend on two differnet querys each based on tblColour. the query qTransparentColours shows all colours where the field Transparent is true and qSolidColours shows all colours where the field Transparent is false.

Now what I want to do is add a menu item to the combobox Colours on my form called "All" independent of the tblColour table.
As you have propably figured out I use the values of this combobox Colours for further functionality. And the reason why I want my tblColour to be intact is that I use the values of it at another place in my application.

So what I want to have as results would be something like:
Transparent: All, Blue, Green Red
Solid: All, White, Yellow, Black

Where at the moment it only shows
Transparent: Blue, Green, Red
Solid: White, Yellow, Black

I did consider doing it by changing the Rowsource of the combobox instead of running a query, but that didn't seem very flexible compared to using the query-solution.
May 25 '07 #1
Share this Question
Share on Google+
2 Replies

puppydogbuddy
Expert 100+
P: 1,923
See this link for a "How To" step by step

http://www.fabalou.com/Access/Forms/...oxextrarow.asp

The step related to setting the default value of the combobox control to * (wildcard) was omitted by accident and needs to be included.
May 25 '07 #2

P: 8
Brilliant - thank you :D
May 29 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.