Multivalue combo box -> query

[yeleek]

Hi,

I've a Access 2007 database which I want to use a field keywords with. The keywords field in my main table is a look up field to another table (called tblkeyword) containing a list of words.

The main form of the main table is configured such as to let me select multiple values from a combo box from the tblkeyword table, all working fine.

I want though to be able to create a search form, which has a combobox also linked to the tblkeyword table, and which then lets me select multiple values. These values would then be passed to a query to retrieve all records with those results.

I've created the search form, and have a combo box linked to the keywords table. It only lets me select single values though. How can I get it to all the selection of multiple values from the tblkeyword?

Thank you

 

[namliam]

A combobox can only select 1 value, period!

You either want a list box, or you have your own type of box... but a combobox will now allow multi select.

 

[yeleek]

http://office.microsoft.com/en-us/access/HA012337221033.aspx

'
When you click the combo box, check boxes appear selected to indicate your choices. You can check or uncheck items in the list and then click OK to submit your choices.

'

 

[namliam]

Note that this on your link is NOT called a combobox. I dont have A2007, so cannot test it but the same page shows how to retrieve information from the "multivalue box"

 

[yeleek]

1) your posts have been unhelpful and quite pointed (rude). Which are hardly inviting to new forum members!!
2) the webpage makes it clear that the control is a combobox. It may be an ms 'fudge' but 'When you click the combo box, check boxes appear selected to indicate your choices. You can check or uncheck items in the list and then click OK to submit your choices'. i.e. the choices are Plural.

Forget this request - I've found another way of doing it.

 

[namliam]

1) I am beeing no where near rude, might be strong worded, but rude? if this is rude.... oh boy...
You may be right in that they have been unhelpfull, but hey I dont have 2007.
2) The webpage does mention combobox yes.... EXACTLY once!
And this is more using the "usual" words/reference for a combobox, but the actual function of this is NOT a combobox.
The title of the page is "Guide to multivalued fields", that is "Guide to multivalued fields" NOT "Guide to comboboxes" or "New comboboxes" or "Comboboxes 2007" anything like that.

At the very bottom of the page you will find the exact explenation of how it works.

 

[yeleek]

1) I am beeing no where near rude, might be strong worded, but rude? if this is rude.... oh boy...
You may be right in that they have been unhelpfull, but hey I dont have 2007.
2) The webpage does mention combobox yes.... EXACTLY once!
And this is more using the "usual" words/reference for a combobox, but the actual function of this is NOT a combobox.
The title of the page is "Guide to multivalued fields", that is "Guide to multivalued fields" NOT "Guide to comboboxes" or "New comboboxes" or "Comboboxes 2007" anything like that.

At the very bottom of the page you will find the exact explenation of how it works.

So why strong worded? you don't know me. My question was not a stupid one. If you don't have access 2007 and can't help then don't answer the the first place. All you've managed to do is make yourself look a like a rude, ignorant prick

 

[namliam]

So why strong worded? you don't know me.

Strong worded cause that is me, and I know you or people like you who dont know the "right words" I was trying to help you getting it right. Your question was about combo's/listboxes that I know as they are the same all over.

My question was not a stupid one.

*cough*yes it was*cough*
No such thing as a stupid question offcourse, but

All you've managed to do is make yourself look a like a rude, ignorant prick

Well I may be all that and more, however for you to make this conclusion of a couple of posts where you feel like I didnt "exactly" help you vs hundreds of people with good experiences.... I hope you wont hold it against me if
1) I am not going to take note of this
2) Make me believe that if anyone is above its not me
3) If I were, make me proud cause I have made hundreds believe otherwize

MAYBE if you had gotten your question RIGHT, perhaps even added the link you later did, then maybe I wouldnt have answered it, becuase yes I dont know (enough) about that...

Then again that would expect you to consider even the possiblity of you making a mistake which is obviously impossible, since your the most perfect, sensible, knowlegable, elegant, well spoken, well manered, friendly person around....

 

[yeleek]

'The main form of the main table is configured such as to let me select multiple values from a combo box from the tblkeyword table, all working fine.'

If you know combo boxes/list boxes. How come you'd not heard of the changes in Access 2007? Is it because your arrogance is larger than your knowledge? Or perhaps because you've spent too many hours on forums trying to gain self worth by posting 100's of 'answers' (which of course may or may not be helpful) rather than actually read about the latest Access version and gaining the knowledge required to actual assist the community? Just a thought....

 

[namliam]

If you know combo boxes/list boxes. How come you'd not heard of the changes in Access 2007?

The business that I am in dont use it, no point in learning a new version of software that is not beeing used is there Mr Smartypants?

Is it because your arrogance is larger than your knowledge?

This is a shot for open goal but I am going to pass on it....

Or perhaps because you've spent too many hours on forums trying to gain self worth by posting 100's of 'answers' (which of course may or may not be helpful)

Which is offcourse how I got to be MVP, VIP and got to have many possitive reviews on this forum alone?? *sure*

rather than actually read about the latest Access version and gaining the knowledge required to actual assist the community? Just a thought....

Yeah sure the whole world lives and breathes A2007 right?
Fact of the truth is I know companies (sadly enough) that still work with Office 95 ! That is Access 2.0 ! Just because my knowlege on the most recent software isnt "up to spec" doesnt make me unable to "assist the community"

Atleast I can assist someone, while you are unable to even help yourself by asking a proper question. Let alone be able to formulate some kind of answer in a fague attempt to help someone other than yourself?

FYI Yes I know A2007, just not good enough to help with it directly... And perhaps, just perhaps, if you had asked the question properly... just perhaps.... maybe then ... A combobox is a combobox, not a list box, not a text box, not a multivalue field.
The functionality of a combobox is that of a ..... combobox...

 

[yeleek]

Mr Smartypants? Not my given name to be honest... but hey thanks I do try to learn new things when I can.

I'm surprised you are MVP not because of your knowledge but because of your public approach - wonder if MS check to see how their MVP's approach members of the public? They certainly appear to expect 'They are teachers, artists, doctors, engineers, as well as technologists, who actively share their high-quality, real-world technical expertise with the community and with Microsoft.'

I've better things to do than carry on posting to a thread which does nothing more than continue to highlight that you appear to take the opportunity to poke holes in newbies posts in a (how did you put it 'strong worded') manner.

You aren't the only one with professional IT qualifications, however the difference between us is. If I don't know the answer I keep my mouth shut, and if someone asks a question which I can answer - I don't take the opportunity to put them down.

 

[namliam]

I'm surprised you are MVP not because of your knowledge but because of your public approach - wonder if MS check to see how their MVP's approach members of the public? They certainly appear to expect 'They are teachers, artists, doctors, engineers, as well as technologists, who actively share their high-quality, real-world technical expertise with the community and with Microsoft.'

They also appreciate a curious and critical eye.... I wont even go into why how or what or even the quality.

I've better things to do than carry on posting to a thread

The first sensible thing you have said, on which I will take your advice

however the difference between us is.

I wouldnt know where to start this list... or where it might end...
Certainly nothing of value in this though