Multiple select from combo box?

[Romper]

Hi all,
I'm currently re-vamping an existing database. What I'd like to know is how to enable a combo box so that I can make and display multiple selections on a form. I have a table called colours which just contains 2 fields "ID" & "Colours". The way the database was previously set up I had a look up column in my records table that would allow me to tick check boxes for various different colours from the colours table. I am changing my database so that no look ups are in tables as I was informed that this was bad practice. So now my look ups will be on the main form for the RecordSource. So how do I now make the combo box for colours allow me to make multiple selections?

 

[John Big Booty]

Combo box's by their nature do not allow multiple selections. However a list box will allow this. See this article for code for dealing with a multi select list box.

 

[Romper]

Thanks once again John,

You're very helpful.