Multiple Value Combobox

[whojstall11]

I have a Multiple Value Combobox that I have linked to one of my forms and I am trying to write some vba code that will allow on update, "if a certain item is clicked open up a different form". Here is the Multiple Value Combobox Multiple value combobox3.JPG Here is the formFormaccess.JPG.

 

[pr2-eugin]

Not many Access programmers are fond of this feature Microsoft has come up with as this is something goes against the basic fundamental rules of RDBMS..

 

[whojstall11]

Ok thank you. But I should probably be able to use a if statement that looks something like this right.

if "Software" = [Lawson Prod] then docmd.open form, etc etc