Multi-value Unbound Combo Box

[JGalletta]

I've read a few posts that state it is not possible to have an unbound multi-value combo box (Access 2007). Many of my bound forms have multi-value combo boxes, and I understand many programmers dislike them as they break some formatting standard rules (or so I've read). Anyway, I have no opposition to them since they work fine for the applications in which I've used them. Is it truth, myth, legend that they cannot be unbound? Is there a way to hardheadedly code this possibility into existence?

Let's see where this gets us,
John

 

[RainLover]

What do you mean by "multi-value combo boxes"

 

[JGalletta]

This is a multi-value combo box.

 

[missinglinq]

It's my understanding that for a Combobox to be 'multi-valued,' in this manner, it has to be Bound to one of the new Multi-value Fields.

What, exactly, are you trying to accomplish with this Combobox?

Linq ;0)>

 

[vbaInet]

Let's see where this gets us,

You already know that most of us are not fans of this feature so we really won't be looking to advance this any further. I will explain why below.

This is a multi-value combo box.

This is a multi-valued field, not a multi-valued combo box. This control does not exist in the toolbox. I remember creating one like the above with three command buttons using a listview control, a combo box and a subform but it required lots of coding. I'm talking advanced stuff here, subclassing etc.

A multi-valued field is a feature specific to Access alone. So if you were going to migrate your database to SQL Server, Oracle, DB2 ...etc you will have recreate the entire table. It's not supported anywhere else except Access. Behind the scenes Access creates the classic one-to-many relationship.

 

[JGalletta]

vbaInet - Thanks for that explanation.

What I am trying to accomplish is this:

I have a form that opens prior to a certain report in which the user may specify certain criteria for the report. The particular field in question is going to be used to remove one or more items from the report using the same field for example:

"tblName.CriteriaName1 <> 'This' AND tblName.CriteriaName1 <> 'That'"

Is there a way to enable the user to acheive this result using only one field? Or will I need to add an additional field(s) in which the user selects the second (third, fourth...) item(s) to be removed from the report?

 

[vbaInet]

If your form is simply a form for setting criteria for the report, you can use a Multi-Select Listbox, loop through the SelectedItems collection of the Listbox and build your criteria using the NOT IN() statement in place of OR.

 

[JGalletta]

Ok, great! Thanks.

 

[vbaInet]

Glad we could help!