Solved Multi Select Combo Box (1 Viewer)

[sctb0825]

I've done a lot of reading but cannot find the answer.

I need to create a combo box where the user can select multiple items.
Also, I would like to be able to enter the quantity of each is possible without too much work.

 

[Uncle Gizmo]

You need a multi select list box.

 

[sctb0825]

will give it a try thanks

 

[isladogs]

A multi select combo is also possible but it requires the use of multivalued fields. I strongly advise you not to use that approach.

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

 

[Uncle Gizmo]

Further to Colin's comment, there is an excellent video by takeshik demonstrating how to code a multi Value combobox.

See video here:-

Multi Value Fields Links - Nifty Access

Multi Value Fields Links Consider a scene at a Microsoft office where an innovative individual, perhaps from the marketing team, suggests, "MS Access requires 'Multivalued Fields' 💡 - our aim is to simplify the usage of MS Access for individuals!" Envision the developers emphatically voicing...

www.niftyaccess.com

 

[sctb0825]

Well the list box approach is not working, I set the Multi Select to simple, no luck, I just get error "this record is not updatable"

 

[Pat Hartman]

Here's a sample that uses the multi-select listbox to filter a form using two different methods.