check box in a combobox

[Shankar14]

How do I put a check box in a combobox so that I can select multiple options from a combobox.

 

[Minty]

Not easily.

Use a multi-select Listbox instead.

 

[CJ_London]

you can't, you have to use a special type of field called a multi-select combo. However they are not recommended because to make them work requires the creation of a hidden many to many join table.

But if you want to go that route, open your table in design view, select your field and click on the lookup tab. Select Combo as the display control, populate the rowsource with whatever you are using and change the allow multiple values property to yes.

As Minty suggests, use a multi select listbox, or take a look at this multi select form example

A multi select form using unbound check boxes

Thought I would put this up since it is a fairly common topic and I have put it up elsewhere - selecting records from a list for onward processing without the need for a table based tickbox. Similar in concept to the conditional formatting version I provided here...

www.access-programmers.co.uk

 

[isladogs]

As already mentioned, combos with checkboxes are possible but only if you use a multivalued field
These are best avoided for many reasons. See my article:

Multivalued Fields

Multivalued fields (MVFs) were introduced with Access 2007. This article explains what MVFs are and how they can be used. However, most experienced developers avoid them completely. This article explains why this feature is really not a good idea

www.isladogs.co.uk

 

[GPGeorge]

How do I put a check box in a combobox so that I can select multiple options from a combobox.

Multi-value combo boxes are bad juju. Avoid them. List boxes are not. Use them instead.

 

[Pat Hartman]

I agree with the others, Multi-value fields are bad juju. However, you can use unbound listboxes that allow multiple items to be selected to use as a filter or criteria for a query. Here's an example

Autofill and other examples

This database shows examples of how autofill works. It also shows examples of filtering with a multi-select listbox. I added an updated version of the database with additional examples.

www.access-programmers.co.uk