Problem On Cascading Combo Boxes

[Batselot]

Hello there everyone, I am having a problem with my access database,rather a small one I hope you could help.Let me explain my problem as simple as I can.First of all I am choosing a course code and then I want to see the learning outcomes related to the course code. I can do that with no problem as you can see from the image I have sent. My problem here is if I want to choose (for example patates and patlıcan). It gives me an error since it acknowledges MED 111 as the main text and I can't choose two of the same things. How can I make it happen that when I choose the 2 related sections of patates and patlıcan;the patates and patlıcan shows up.
Thanks in advance,

[Minty]

Have a look here http://www.baldyweb.com/CascadingCombo.htm
There is a example database you can download as erll

[ranman256]

Combos aren't really for multi pick.
thats a list box.

pick 1 in cbo1
that limits choices in cbo2
etc

[ssanfu]

My $0.02 worth.....

1) It looks like you are doing data entry in a table. This is not a good idea - you should always use a form.

2) From the image, it looks like you have defined a Multi-Value Field in a table.
Most experienced Access developers do not/will not use MVFs (nor Look Up fields in tables, nor Calculated Fields in tables). Microsoft did not fully implement MVFs - it is easy to get the data in, but a *real* PITA to get the data out.

[isladogs]

Agree with the consensus to avoid multivalue fields like the plague.
Here's an article from my website explaining why: http://www.mendipdatasystems.co.uk/m...lds/4594468763

And here's another example app with 5 cascading comboboxes: http://www.mendipdatasystems.co.uk/c...xes/4594455723