Combo Box doesn't go away (1 Viewer)

[SusanCB]

Hi, all -- I have a combo box on a form that lets the user select one or more locations using a checkbox. However, when the user makes his or her selections and clicks "OK," the combo box doesn't go away. Any thoughts on what might be causing this? Thanks!

 

[John Big Booty]

How do you mean the Combo Box doesn't go away

I'm also curious as to how you have managed to set a Combo Box up to allow multiple selection from check boxes

This speaks of some serious structural problems in your DB.

 

[SusanCB]

Perhaps, but the checkboxes-in-combo-box method has worked perfectly on another form in the same database. (The settings are identical, so I am really not sure what's happening.) The user can check a selection(s) -- i.e., Bronx and Brooklyn -- and a check mark shows up in the appropriate box. But when he/she clicks "OK," nothing happens. (Clicking "Cancel" works.)

 

[SusanCB]

OK, I'm not sure why this worked, but I just updated the link between the affected table in my back-end database, and the form and combo box now function perfectly. Thanks anyway.

 

[boblarson]

I'm also curious as to how you have managed to set a Combo Box up to allow multiple selection from check boxes

P - it is in Access 2007 or 2010 where you have multi-valued fields (which most of us abhor).

 

[SusanCB]

Yes, I'm using Access 2007. Apologies if I have somehow behaved abhorrently.

 

[boblarson]

Apologies if I have somehow behaved abhorrently.

You are just using what Microsoft provided, however most of the professional developers here abhor what Microsoft has done in regards to adding things like mult-valued fields and other things which make it SEEM easy to use but then when you get into them, you find that it is a pain in the backside to actually use them efficiently where if you used a different approach, and resisted the lure of the "eye candy" which they have provided, it would turn out to be easier to deal with when you need to get the data back out in a query and such.

 

[John Big Booty]

Is check box functionality within a Combo an '07 too

 

[vbaInet]

Is check box functionality within a Combo an '07 too

We can only wish. It pops up when you click on a Multivalued field but the actual control is hidden and is not available in the Toolbox or as an ActiveX control. I remember needing to create one like this.

 

[boblarson]

Is check box functionality within a Combo an '07 too

Yes, it is. Like this:

 

[John Big Booty]

Hi Bob, I've just been having a fool around with my version 0f '07, and I'm unable to find the multi-select option for Combo Boxes or get a functional Check box in a Combo. Where are these feature hidden

 

[boblarson]

Hi Bob, I've just been having a fool around with my version 0f '07, and I'm unable to find the multi-select option for Combo Boxes or get a functional Check box in a Combo. Where are these feature hidden

P:

What you would do is to go add your field using number and set it as a lookup field (hence not good), and in the lookup tab you would set the multivalue property to yes.

 

[John Big Booty]

P:

What you would do is to go add your field using number and set it as a lookup field (hence not good), and in the lookup tab you would set the multivalue property to yes.

Well, that's satisfied my curiosity, and explains why I couldn't see any of those things when I was setting up as I normally would